Note
This variable is available starting with V1.4.
Description
character_set_client specifies the character set for statements sent from the client.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle-compatible mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of a global system variable.Session level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to view the value of a session system variable.
Modify variables
Global level
The
systenant can directly modify the value of a global system variable.A MySQL user tenant can modify the value of a global system variable only if it has the
SUPERorALTER SYSTEMprivilege.An Oracle user tenant can modify the value of a global system variable only if it has the
ALTER SYSTEMprivilege.
Session level
The
systenant and all user tenants can directly modify the value of a session system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | utf8mb4 |
| Value range |
|
| Scope |
|
| Modifiable | Yes. You can execute the SET statement to modify the value. |
| Nullable | Yes |
Examples
Set the character set for statements sent from the client to utf8mb4.
Global level
obclient> SET GLOBAL character_set_client ='utf8mb4';Session level
obclient> SET character_set_client ='utf8mb4';