MySQL identifier case sensiti.pdf

Http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
How table and database names are stored on disk and used in MySQL is affected by lower_case_table_namesSystem variable, which you can set when starting Mysqld. lower_case_table_namesCan take the values shown in the following table.
On UNIX, the default value lower_case_table_namesIs 0.
On Windows the default value is 1.
On Mac OS X, the default value is 2.

Value	Meaning
0	Table and database names are stored on disk using the lettercase specified inCREATE TABLEOrCREATE DATABASEStatement. Name comparisons are case sensitive. Note that if you force this variable to 0--lower-case-table-names=0On a case-insensitive filesystem and accessMyISAMTablenames using different lettercases, index partition uption may result.
1	Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.
2	Table and database names are stored on disk using the lettercase specified inCREATE TABLEOrCREATE DATABASEStatement, but MySQL converts them to lowercase on lookup. Name comparisons are not case sensitive.Note: This WorksOnlyOn filesystems that are not case sensitive!InnoDBTable names are stored in lowercase, aslower_case_table_names=1.