[opencms-dev] RV: Beta 2 - case-sensitiveness in MySQL 4

[Mariano Barcia]

Claus,

This is the kind of minor issues that causes major problems to the users and, IMHO, they should be fixed wherever possible. We had a
similar problem last year with OpenCMS 5 when migrating from MySQL to Oracle, and it really affected our project at that time.

Let me confirm what the problem is: 
For table names, scripts are using lower-case, and all the queries are using upper-case. When installing under a case-insensitive
environment, the problem does not arise. When migrating or installing under a case-sensitive environment, mysql needs to be told to
ignore case for table-names. 

So far, this problem can be fixed easily like you pointed out, setting the proper line in my.cnf. But a bigger issue is: is OpenCMS
6 consistent when dealing with case-sensitivity across different databases? (i.e. MySQL and Oracle)

Fixing the problem should not be difficult and my company could allocate efforts to solve this issue with minimal help from Alkacon.
Maybe it's just a matter of documenting this issue so nobody gets noticed at installation.

I look forward to your comments, and thanks very much for your help

--mariano

-----Mensaje original-----
De: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] En nombre de Claus Priisholm
Enviado el: Lunes, 18 de Abril de 2005 03:48 a.m.
Para: The OpenCms mailing list
Asunto: Re: [opencms-dev] RV: Beta 2 - case-sensitiveness in MySQL 4

I was merely stating that Alkacon is not to blame for the poor 
cross-platform experience provided by MySQL. As it was stated in the 
original question the problem came about when they moved an existing 
database from one MySQL server to another - a step that must be taken 
with care when it involves moving from one type of filesystem to 
another.

Of course if 6b2 cannot install or run out of the box on a 
case-sensitive MySQL then I would say it is a problem that should be 
fixed. As I am always using MySQL in case-insensitive mode I cannot 
comment on that setup, but neither was the original post as they were 
moving an existing database rather than installing 6b2 from scratch.

On 17/4-2005, at 19.26, Geoff Winkless wrote:

> Claus Priisholm wrote:
>
>> Great that it works for you now
>>
>> Most of the SQL statements are per default written as upper case in 
>> the source code, so I don't think it is considered a bug.
>> Maybe one could blame mysql for not making case insensitivity the 
>> default since it is their choice to depend on the underlying 
>> filesystem as far as table-naming goes.
>
>
> So you're saying you don't think the system should be fixed, even 
> though it will cause no problems to anyone else and will stop this 
> occurring for some other poor sod who just happens to have a 
> case-sensitive database?  Nice attitude, dude.
>
> Geoff
>
>
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please 
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
--
Claus Priisholm, CodeDroids ApS
+45 48 22 46 46
email: cpr (you-know-what) interlet.dk - cpr (you-know-what) 
codedroids.com
skype: claus_priisholm
http://www.interlet.dk - http://www.codedroids.com



_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev