【 TiDB 使用环境】生产环境
753
【复现路径】做过哪些操作出现的问题
mysql> set global collation_connection=‘utf8mb4_general_ci’;
Query OK, 0 rows affected (0.36 sec)
mysql> show variables like ‘%coll%’;
±--------------------------------------±-------------------+
| Variable_name | Value |
±--------------------------------------±-------------------+
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_bin |
| collation_server | utf8mb4_general_ci |
| default_collation_for_utf8mb4 | utf8mb4_general_ci |
| tidb_enable_collect_execution_info | ON |
| tidb_hash_exchange_with_new_collation | ON |
±--------------------------------------±-------------------+
6 rows in set (0.20 sec)
【遇到的问题:问题现象及影响】
【没有生效,会话修改可以生效