【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】4.2.3.1
【 使用版本 】4.2.3.1
【问题描述】使用obclient或mysql登录后show variables like “%char%”;显示character_set_client,character_set_connection,character_set_results均为latin1
+--------------------------------------+---------+
| Variable_name | Value |
+--------------------------------------+---------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb4 |
| validate_password_special_char_count | 0 |
+--------------------------------------+---------+
OB默认字符集不是utf8mb4吗,我看文档上这几个参数默认值也是utf8mb4,怎么全局修改啊?
我使用SET global character_set_client = utf8mb4;
SET global character_set_results = utf8mb4;
SET global character_set_connection = utf8mb4;
set session character_set_client=‘utf8mb4’ ;
set session character_set_connection =‘utf8mb4’;
set session character_set_results =‘utf8mb4’;都不行,重新连接就恢复了。