Case sensitivity

[stukelly]

Hi,

I have a linux reseller account. Is is possible to set MySQL to be case insensitive?

http://dev.mysql.com/doc/refman/5.0/...nsitivity.html

Thanks Stu

[247h]

My understanding of this part of the reference you gave "...Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. This means database and table names are case sensitive in most varieties of Unix, and not case sensitive in Windows" means that no, you probably cannot make MySQL case-insensitive, however I'm no outright expert on this.

For these sorts of questions I'd normally email Support directly ...

[DavidAllen]

I agree with 247h - if your on shared unix hosting there is virtually zero chance of getting the default changed.

Out of interest - why would you want it case insensitive in the first place?

[eUKhost.com]

one can compile Aspell Pspell with Apache to ignore case but this is limited to webpages served by Apache. I've never seen anything for MySQL so far.

[stukelly]

Originally Posted by DavidAllen

Out of interest - why would you want it case insensitive in the first place?

A programming colleague was just being lazy. He used SQL queries like this

select * from PRODUCTS;
select * from proudcts;

Which would never have worked.

Anyway he sorted it now he is using upper-case throughout.

Cheers Stu