Overview
character_set_system is used to view the character set used by the server.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can use theSHOW VARIABLESstatement and theinformation_schema.GLOBAL_VARIABLESview to view the values of global system variables.Session level
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement and theinformation_schema.SESSION_VARIABLESview to view the values of session system variables.
Modify variables
The current variable cannot be modified.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | utf8mb4 |
| Effective Scope |
|
| Modifiable | No, read-only is the only supported mode. |
Sample query
Check the character set used by the server.
obclient> SHOW GLOBAL VARIABLES LIKE 'character_set_system';
The query result is as follows:
+----------------------+---------+
| Variable_name | Value |
+----------------------+---------+
| character_set_system | utf8mb4 |
+----------------------+---------+