[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