lower_case_table_names

USAGE

The lower_case_table_names system variable can have its default value configured via SkySQL Configuration Manager.

DETAILS

The lower_case_table_names system variable determines whether table names, table aliases, and database names are compared in a case-sensitive manner, and whether tablespace files are stored on disk in a case-sensitive manner.:

• When set to 0 (the default on Unix-based systems), table names, table aliases, and database names are compared in a case-sensitive manner.

• When set to 1 (the default on Windows), table names and database names are stored in lowercase and compared in a case-insensitive manner.

• When set to 2, table names and database names are stored as declared, but they are compared in lowercase. This value is rejected if the server is using a case-sensitive file system. If set to 0 and the server is using a case-insensitive file system, the value is automatically set to 2. For example, this would happen on Mac OS X when using HFS+ or APFS, except when APFS is used in case-sensitive mode. If set to 2 and the server is using a case-sensitive file system, the value is automatically set to 0. For example, this would usually happen on Linux, since it almost always uses a case-sensitive file system.

CHANGE HISTORY

EXTERNAL REFERENCES

• This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the lower_case_table_names page in the MariaDB Enterprise Documentation.