lower_case_table_names specifies the case sensitivity.
| Property | Description |
|---|---|
| Parameter type | Int |
| Default value | 1 |
| Value range | * 0: Table names are stored in the specified lettercase, and name comparisons are case-sensitive. * 1: Table names are stored on the disk in lowercase, and name comparisons are case-insensitive. * 2: Table names are stored in the specified lettercase and are converted to lowercase for comparison. |
| Effective scope | GLOBAL |
| Involved in serialization | Yes |
| Modifiable | No. The value is specified only in the command line during OBServer startup and cannot be modified by using an SQL statement after the startup. |
Note
This variable is valid only for Database and Table object names in MySQL mode.