Note
This variable is available starting with V1.4. This variable is used only for compatibility with MySQL. The related features are not supported. You can query and set this variable. The setting does not take effect but does not return an error.
Description
collation_database specifies the default character set and collation for the database.
Applicability
This variable is applicable only to OceanBase Database in MySQL mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a global system variable.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of a session system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | utf8mb4_general_ci |
| Value range | |
| Scope | |
| Modifiable | No. This variable is read-only. |
| Nullable | Yes |