[TYPO3-dev] t3lib_TCEmain: quotes around column names

[Steffen Kamper]

Hi,

Jigal van Hemert schrieb:
> Hi Dmitry,
> 
>>> Maybe it would be a good idea to quote all column names with backticks
>>> to avoid such problems. What do you think?
>> I think it is better not to use reserved keywords...
> 
> Maybe we should all get access to your crystal ball ;-)
> 
> How are developers supposed to avoid the reserved keywords of all DBMSs
> that TYPO3 will ever support of all future versions of these DMBSs? MySQL
> advices to use backticks around column names to make queries future proof
> (regarding reserved keywords).
> 
> (I hope that the content storage engine of TYPO3 v5 will have its own
> mechanism to avoid such problems and extensions will never have to build
> SQL queries directly...)
> 

in kickstarter (actual version) all keywords are printed out, maybe we 
should add a test too.
If unsure the list helps:
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

If this is respected no problems occur.

vg Steffen