[TYPO3-dev] DBAL, Templavoila, PostgreSQL: case sensitivity in SQL

Dmitry Dulepov 9f4eetb02 at sneakemail.com
Thu Feb 15 09:17:48 CET 2007


Hi!

Mathias Behrle wrote:
> 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?).

MySQL is not case-sensitive only on Windows.

I fixed that issue in SVN, it should appear in 1.3.1.

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)




More information about the TYPO3-dev mailing list