[TYPO3-english] TYPO3 4.3.0-dev with Oracle

[Michael Miousse]

Le Sat, 02 May 2009 16:45:44 -0500, Ries van Twisk a écrit :

> On May 2, 2009, at 11:27 AM, Georg Ringer wrote:
> 
>> David Bruchmann schrieb:
>>> I suppose that many extensions arent't compatible with other databases
>>> than mySql.
>>
>>
>> all which follow the rules. extension which don't are in many times
>> crap... ;)
> 
> 
> George,
> 
> don't forgot that there is a problem with MySQL aswell in such a way
> that MySQL doesn't work with standards. And people don't know about the
> MySQL oddities
> and how to make tools work easily across database vendors.
> 
> I personally had problems with mixing upper/lowercase fields names
> within a MySQL DB.
> 
> MySQL allows this mixing of field name cases while most, of not all
> database change the case it to all uppercase (DB2 I believe) or all
> lowercase (PostgerSQL).
> 
> So this query:
> 
> SELECT MyField FROM table;
> 
> Might return a different field name cases in your result sets.
> 
> Even TYPO3 core is not solid and uses mixed cases, which is IMHO not
> playing really nice.
> 
> I hope I made my self clear in my crappy example.
> 
> Ries

and by the way any extension using joins in sql query (more than one)
will not work. their is a bug in t3lib_sql_parser  on query parsing.

i'll try to fix it if i find time for it but until then extension like powermail 
which follow the guidline i'll give error message in backend

cheer

Miousse