[TYPO3-dev] strange enableFields SQL with T3 4.0

[Florian Schaeffer]

>> So would there be a way to handle this query via DBAL ?
>>
>> - oracle, mssql and mysql know this function and use the same syntax
> 
> 
> Does Oracle support now multiple strings in CONCAT? It used to take 
> exactly 2 arguments for CONCAT
You'reright, I just tried it on Oracle 9 and 10 and it sticks to 2 
arguments :-(

> It is possible that DBAL/adoDB already support CONCAT somehow.
> 
> A possible is IMHO to use a set of stored procedures for other DBs that 
> emulate the more common (and useful) Mysql functions.

Yes, but then again, how about using different systems like SQLite or DB 
which not support those stored procedures ?
I think that there is a need for normalisation of the way 
multiple-value-single-strings are handled right now.
See the other thread in about future of TYPO3.

But nonetheless the concat expression speeds up the process so it might 
be handy to have such TIPS-N-TRICKS for the next implementation.

Florian