MySQL Case-sensitive issues

Tag: Style color AR uses the for SP file data on

One, 1 CREATE TABLE name (name VARCHAR (10));

        for this table, by default, the results of the following two queries are the same:

        select * from TABLE NAME WHERE name= ' clip ';

        select * from TABLE NAME WHERE name= ' Clip ';

        mysql default query is case-insensitive, if you need to differentiate him, you must build the table, Binary identifies the sensitive attribute.

CREATE TABLE NAME (

Name VARCHAR (Ten) BINARY

       );

2 Implementation of SELECT * from TABLE in SQL statement NAME where BINARY name= ' Clip ';

3 Setting the character set:

UTF8_GENERAL_CI--Case insensitive

utf8_bin--Case Sensitive

II, MySQL under Windows is not case-sensitive, the script file into MySQL after the table name is automatically converted to lowercase, the result is There is an error when you want to put the database export on a Linux server. Because the table names in Linux are case-sensitive and cannot find a table, many of them say that changing the MySQL settings under Linux makes it not case-sensitive, but there is no way to make Windows case-insensitive in turn. In fact the method is the same, the corresponding changes in the Windows MySQL settings on the line.

Specific operation:

Add a line to the MySQL configuration file My.ini:

Lower_case_table_names = 0

Where 0: Case sensitive, 1: Case insensitive

MySQL under Linux database name, table name, column name, alias casing rules are like this:

1, database name and table name are strictly case-sensitive;

2, the table alias is strictly case-sensitive;

3, the column name and the alias of the column in all cases are ignored case;

4, variable names are also strictly case-sensitive; MySQL is case-insensitive under Windows

MySQL Case-sensitive issues