MySQL table name ignores case

View case Sensitivity
Mysql> Show variables like "%case%";
+------------------------+-------+
| variable_name | Value |
+------------------------+-------+
| Lower_case_file_system | OFF |
| Lower_case_table_names | 0 |
+------------------------+-------+
2 rows in Set (0.00 sec)




Today depressed dead, in the Linux downgrade a program old said can't find the table, but I obviously built a table, under the command line of MySQL can also find, why the program can't find the table?
Later asked a teacher to take care of, the original is the Linux MySQL default is to distinguish the table name case, hey, get so old, killed me.
The way that MySQL does not differentiate between table name capitalization is actually simple:
1. Log in with root, modify/ETC/MY.CNF
2. Add a line under [mysqld]: Lower_case_table_names=1
3. Restart the database to


Today, when the test, encountered some problems, obviously see the data, is not found out, and later discovered that under Linux, MySQL table name is case-sensitive, and under Windows is not differentiated, from Windows exported from the data script is used in lowercase,
The table names in the SQL generated by hibernate are uppercase, so the data cannot be found.
Google has some information, modify a MySQL parameter can be, as follows:
Under Ubuntu, the/etc/mysql/my.cnf file
[Mysqld] the back plus
Lower_case_table_names=1
0, case-sensitive; 1, no distinction
It seems that in/etc/my.cnf, under Ubuntu, this can not be used.
Then restart MySQL
Sudo/etc/init.d/mysql restart
Note: (The following excerpt from the online)
MySQL under Linux database name, table name, column name, alias casing rules are as follows:
1. Database and table names are strictly case-sensitive
2. Table aliases are strictly case-sensitive
3. The alias of the column name and the column is case-insensitive in all cases
4. Variable names are also strictly case-sensitive

MySQL table name ignores case