lower_case_table_names

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.

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

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.

PARAMETERS

Dynamic

No

Scope

Global

Data Type

INT UNSIGNED

Minimum Value

0

Maximum Value

2

Default Value

0

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

0 (choices: 0, 1, 2)

AWS

HA (Primary/Replica)

10.5

0 (choices: 0, 1, 2)

AWS

Transactional Standalone

10.4

0 (choices: 0, 1, 2)

AWS

Transactional Standalone

10.5

0 (choices: 0, 1, 2)

AWS

Distributed Transactions

10.5

1 (choices: 0, 1, 2)

GCP

ColumnStore

10.5

0 (choices: 0, 1, 2)

GCP

ColumnStore Multi

10.5

0 (choices: 0, 1, 2)

GCP

Galera

10.4

0 (choices: 0, 1, 2)

GCP

Galera

10.5

0 (choices: 0, 1, 2)

GCP

HA (Primary/Replica)

10.4

0 (choices: 0, 1, 2)

GCP

HA (Primary/Replica)

10.5

0 (choices: 0, 1, 2)

GCP

HTAP

10.5

0 (choices: 0, 1, 2)

GCP

Transactional Standalone

10.4

0 (choices: 0, 1, 2)

GCP

Transactional Standalone

10.5

0 (choices: 0, 1, 2)

GCP

Distributed Transactions

10.5

1 (choices: 0, 1, 2)

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES