Wednesday, April 7, 2010

[Level 2] Case sensitive in MySQL.

The MySQL in Unix system, the database name and table name are case sensitive as default. But in Windows, they are case insensitive. That is because the file system in Unix are case sensitive but in Windows is not.
So, the easy way to solve the problem or for compatibility between different platform, you can choose the case sensitive or not in your MySQL database.
The way to setting it is the by the option "low-case-table-name", and there are three values (0,1,2) for this option.

0: Table and database names are stored on disk using the lettercase specified as DDL statement.
1: Table names are stored in lowercase on disk and name comparisons are not case sensitive.
2: Table and database names are stored on disk using the lettercase specified as DDL statement, but MySQL converts them to lowercase on lookup.

Wish this helps.

regards,
Stanley Huang