[TYPO3-dev] t3lib_TCEmain: quotes around column names

[Jigal van Hemert]

Hi Steffen,

>>>> 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...
>>
>> How are developers supposed to avoid the reserved keywords of all DBMSs
>> that TYPO3 will ever support of all future versions of these DMBSs?
> 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

Both these suggestions only apply to current versions of the database on
the installation the extensions was developed on.

How do you prepare for MySQL 6.x, 7.x, Oracle, MSSQL, Progress, ...?

-- 
Jigal van Hemert.