Note
This variable was introduced in OceanBase Database V1.4.
Description
lower_case_table_names specifies whether object names are case-sensitive for storage and comparison.
Applicability
This variable is applicable to only OceanBase Database in MySQL mode. It takes effect only on the names of databases and tables.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 1 |
| Value range |
|
| Effective scope | Global |
| Modifiable | No. 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. |
Example
Set the lower_case_table_names variable to 0 when you use the CREATE TENANT statement to create a tenant.
obclient> 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;