https://aznot.com/index.php?action=history&feed=atom&title=MySQL%2FTweaks 2026-05-08T16:34:24Z Revision history for this page on the wiki MediaWiki 1.41.0 https://aznot.com/index.php?title=MySQL/Tweaks&diff=3010&oldid=prev 2016-03-09T20:54:43Z

<p>Created page with &quot;[http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html Identifier Case Sensitivity] How table and database names are stored on disk and used in MySQL is affected...&quot;</p> <p><b>New page</b></p><div>[http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html Identifier Case Sensitivity]<br /> <br /> How table and database names are stored on disk and used in MySQL is affected by the lower_case_table_names<br /> system variable, which you can set when starting mysqld. lower_case_table_names can take the values shown<br /> in the following table. On Unix, the default value of lower_case_table_names is 0. On Windows the default<br /> value is 1. On Mac OS X, the default value is 2.<br /> <br /> Value Meaning<br /> 0 Table and database names are stored on disk using the lettercase specified in the CREATE TABLE<br /> or CREATE DATABASE statement. Name comparisons are case sensitive. Note that if you force this<br /> variable to 0 with --lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM<br /> tablenames using different lettercases, index corruption may result.<br /> 1 Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL<br /> converts all table names to lowercase on storage and lookup. This behavior also applies to<br /> database names and table aliases.<br /> 2 Table and database names are stored on disk using the lettercase specified in the CREATE TABLE<br /> or CREATE DATABASE statement, but MySQL converts them to lowercase on lookup. Name comparisons<br /> are not case sensitive. Note: This works only on filesystems that are not case sensitive! InnoDB<br /> table names are stored in lowercase, as for lower_case_table_names=1.</div>

Kenneth