说明

该语句将三个会话系统变量 ， character_set_connection 和 character_set_results 设置为给定的字符集。将 character_set_connection 设置为 charset_name ，将 collation_connection 设置为 charset_name 的默认排序规则。

  • 设置数据库的字符集和排序规则。
  1. OceanBase(admin@test)>SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci';
  2. Query OK, 0 rows affected (0.00 sec)
  4. OceanBase(admin@test)>show variables like 'character_set_c%';
  5. +--------------------------+---------+
  6. | Variable_name            | Value   |
  7. +--------------------------+---------+
  8. | character_set_client     | utf8mb4 |
  9. | character_set_connection | utf8mb4 |
  12. OceanBase(admin@test)>show variables like 'collation_connection';
  13. +----------------------+--------------------+
  14. | Variable_name        | Value              |
  15. +----------------------+--------------------+
  16. | collation_connection | utf8mb4_general_ci |
  17. +----------------------+--------------------+
  18. 1 row in set (0.05 sec)
  21. OceanBase(admin@test)>SET NAMES 'gbk';
  22. Query OK, 0 rows affected (0.02 sec)
  24. OceanBase(admin@test)>show variables like 'character_set_c%';
  25. | Variable_name            | Value |
  26. +--------------------------+-------+
  27. | character_set_client     | gbk   |
  28. | character_set_connection | gbk   |
  29. +--------------------------+-------+
  30. 2 rows in set (0.01 sec)
  33. OceanBase(admin@test)>show variables like 'collation_connection';
  34. +----------------------+----------------+
  35. | Variable_name        | Value          |
  36. +----------------------+----------------+
  37. | collation_connection | gbk_chinese_ci |
  38. +----------------------+----------------+