[TYPO3-english] TYPO3 4.3.0-dev with Oracle
mmiousse at infoglobe.ca
Sun May 3 04:43:29 CEST 2009
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... ;)
> 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.
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
More information about the TYPO3-english