[TYPO3-dev] t3lib_TCEmain: quotes around column names

Karsten Dambekalns karsten at typo3.org
Wed Jun 10 10:05:37 CEST 2009


Hi.

On 10.06.2009 8:50 Uhr, Christian Kartnig wrote:
> Maybe it would be a good idea to quote all column names with backticks
> to avoid such problems. What do you think?

Avoid reserved words, the backtick is in fact even worse, as it is again 
MySQL specific, ANSI SQL uses double quotes names and single quotes for 
literals. No backticks at all.

Then rather use double quotes and switch so ANSI mode in the connection 
startup - but that will probably break tons of lousy SQL out there. :)

Regards,
Karsten




More information about the TYPO3-dev mailing list