collation_server

Description

collation_server specifies the default character set and collation of the server.

Privilege requirements

• Query variables

  • Global level

    sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode) to obtain the values of global system variables.

  • Session level

    sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to obtain the values of session system variables.

• Modify variables

  • Global level

    • sys tenant can directly modify the values of global system variables.

    • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the values of global system variables.

    • Oracle user tenants must have the ALTER SYSTEM privilege to modify the values of global system variables.

  • Session level

    sys tenant and all user tenants can directly modify the values of session system variables.

Attributes

Examples

Set the default character set and collation of the server to utf8mb4_general_ci.

• Global level

  obclient> SET GLOBAL collation_server ='utf8mb4_general_ci';
  

• Session level

  obclient> SET collation_server ='utf8mb4_general_ci';