Note
This variable is available starting with V1.4.
Description
lower_case_table_names specifies whether to be case-sensitive.
Applicability
This variable applies only to OceanBase Database in MySQL mode and only affects the names of databases and tables.
Privilege requirements
Query variables
You can execute the
SHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a Global system variable in thesystenant and all user tenants.Modify variables
After a tenant is created, you cannot modify the value of this variable by executing an SQL statement.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | int |
| Default value | 1 |
| Value range |
|
| Scope | Global |
| Modifiable | No. You can specify this variable only when you execute the CREATE TENANT statement to create a tenant. After a tenant is created, you cannot modify the value of this variable by executing an SQL statement. |
Examples
The following example shows how to create a tenant and specify the value of the lower_case_table_names variable as 0:
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;