MySql case insensitive

[zzman]

I recently moved my database to a new server. And all of a sudden all my queries have become case sensitive. Any Ideas

[zzman]

Its a windows to linux issue. Is there a workaround else ill hev to change all my scripts ??

[MarkR]

No, it's nothing to do with Windows and Linux (I assume you mean your DATA, not object names).

What you need to do is set the collation appropriately on your database.

If it's set case-sensitive, it will be case sensitive, otherwise it will not be.

e.g. setting the collation utf8_general_ci will mean that your data are in utf8 and case insensitive.

This is also related to getting your encodings right. Ensure that you do so. Always.

Mark