mysql 大小寫取消敏感設定

標籤：mysql   low case   

mysql 大小寫取消敏感設定

#mysqld --SET-lower_case_table_names=1;

或者在mysql server的設定檔中添加配置項:

vi /etc/my.cnf

lower_case_table_names=1 

該變數值的詳細定義如下:

Value	Meaning
0	Table and database names are stored on disk using the lettercase specified in the CREATE TABLE orCREATE DATABASE statement. Name comparisons are case sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption 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 in the CREATE TABLE orCREATE DATABASE statement, but MySQL converts them to lowercase on lookup. Name comparisons are not case sensitive. This works only on file systems that are not case sensitive! InnoDB table names are stored in lowercase, as forlower_case_table_names=1.

本文出自 “於昊(Pcdog)的部落格” 部落格，請務必保留此出處http://433266.blog.51cto.com/423266/1869824

mysql 大小寫取消敏感設定