[TYPO3-english] TYPO3 4.3.0-dev with Oracle

[Ries van Twisk]

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