lower_case_table_names specifies whether object names are stored and compared in a case-sensitive manner.
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 1 |
| Value range | 0: Object names are stored in the specified case and compared in a case-sensitive manner.1: Object names are stored in lowercase and compared in a case-insensitive manner.2: Object names are stored in the specified case and compared in a case-insensitive manner. |
| Applicable scope | Global |
| Involved in serialization | Yes |
| Modifiable | You can set the variable when you use the CREATE TENANT statement to create a tenant. After the tenant is created, you cannot modify the variable by executing SQL statements. |
Note
This variable is valid only for the names of databases and tables.
The following example shows how to set the lower_case_table_names variable to 0 when you use the CREATE TENANT statement to create a tenant:
CREATE TENANT IF NOT EXISTS t1 zone_list = ('zone1'), primary_zone = 'zone1', resource_pool_list = ('pool1') SET ob_compatibility_mode = 'mysql',lower_case_table_names = 0;