[RESOLVED] Mysql Global Case-Sensitivity?

[ednark]

Is there a way to globally tell mysql 4.0 that I want all queries or all columns to be case sensitive be default (like in postgres)?

I know Mysql searches case-insensitive by default.

I know you can collate/binary/blob a column to be always case-sensative on a column by column basis.

I know you can collate/binary/strcasecmp columns in a specific query.

I know you can set case-sensitivity of Table/Index names a conf file.

I have a large existing codebase on a large existing database that SHOULD be case-sensative and is not. I would like to not have to go through file by file or table by table and make changes.

Does anyone know of a global conf thingy I can set that would fix my problems?

[Roger_Ramjet]

You can specify charset and collation at the server, database, table and column level. So, yes, it is possible to set the default as you require. character set and collation

[ednark]

Ah wonderful, just what I was looking for. I missed that whole section in the docs. Much thanks!