Http://www.2cto.com/database/201202/121253.html 1, MySQL is case-sensitive by default, use show Variables like '%table_names ' to view Lower_ The value of the Case_table_names, 0 stands for the distinction, 1 represents not differentiated.
2, MySQL for type varchar data is not case-insensitive by default, but if the field is encoded with "*_bin", it will make MySQL case-sensitive.
3. mysql Policy for field names is the same as varchar type data. That is, the default is case-insensitive, but if the field is encoded with "*_bin", it will make MySQL case-sensitive.
4. mysql Policy for table names is the same as varchar type data. That is, the default is case-insensitive, but if the table is encoded with "*_bin" it will make MySQL case-sensitive.
5, if you follow the first item to view the value of Lower_case_table_names is 0, but need to make MySQL default case-insensitive, you need to add parameters in the MySQL configuration file and restart the MySQL database. The MySQL configuration file is modified as follows:
[Mysqld]
...
Lower_case_table_names = 1
6, Note: Table and field encoding as far as possible to inherit the database encoding (not clearly specified as inheritance), so as not to cause confusion.
Question about whether MySQL table name/field name/field value is case-sensitive
