[TYPO3-dev] DBAL,Templavoila,PostgreSQL: case sensitivity in SQL
Mathias Behrle
expi311203 at gmx.de
Wed Feb 14 21:45:08 CET 2007
Hi all,
I am currently implementing merrychristmas.typo3.org on PostrgeSQL to
get a first time running setup.
I am asking here for advice, where to direct further changes:
in class.tx_templavoila_referenceelementswizard.php:
$res = $TYPO3_DB->exec_SELECTquery (
'uid, header, bodytext, sys_language_uid, colpos',
...
Field in question and throwing error is colPos in tt_content, because
PostgreSQL is case sensitive in field names (MySQL doesn't seem to be?).
At other places in the code field colPos is addressed correctly, so I am
inclined to suppose, that it should be changed in templavoila. But first
I wanted to ask about the general opinion, if this problem is supposed to be
rather DBAL related and if case insensitivity should be implemented
there.
Thanks for your input,
Mathias
More information about the TYPO3-dev
mailing list