[TYPO3-dev] Reserved keywords on fields and table names in the database

[Martin Kutschker]

Martin Kutschker schrieb:
> Ries van Twisk schrieb:
>> Hey All,
>>
>> I am heaving slowly more and more problems with reserved keywords on
>> different databases and versions.
> 
> I've argued in vain that TYPO3 should quote SQL identifiers. The best 
> answer I got is that DBAL "takes care of that".

Interestingly I even had to argue with a DB programmer who normally 
works with Oracle that it is a good idea to quote identifiers.

Masi

PS: I have proposed a quoteIdentifier method for t3lib_db 
($GLOBALS['TYPO3_DB']). This function is easy enough to use in a 
extension. But to make TYPO3 use it consistently in all DB functions is 
a big task.