[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