character_set_connection

Description

character_set_connection specifies the character set to be used for converting received statements.

Privilege requirements

• Query variables

  • Global level

    The sys tenant and all user tenants can query the value of Global system variables by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle-compatible mode) and the information_schema.GLOBAL_VARIABLES view (MySQL-compatible mode).

  • Session level

    The sys tenant and all user tenants can query the value of Session system variables by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle-compatible mode) and the information_schema.SESSION_VARIABLES view (MySQL-compatible mode).

• Modify variables

  • Global level

    • The sys tenant can directly modify the value of Global system variables.

    • MySQL user tenants need to have the SUPER or ALTER SYSTEM privilege to modify the value of Global system variables.

    • Oracle user tenants need to have the ALTER SYSTEM privilege to modify the value of Global system variables.

  • Session level

    The sys tenant and all user tenants can directly modify the value of Session system variables.

Attributes

Examples

Set the character set to be used for converting received statements to utf8mb4.

• Global level

  obclient> SET GLOBAL character_set_connection ='utf8mb4';
  

• Session level

  obclient> SET character_set_connection ='utf8mb4';