tdsql 修改 character_set_connection

TDSQL 修改

character_set_connection | utf8 |

到：

character_set_connection | utf8mb4 |

 

修改 my.cnf  即可

init_connect='SET NAMES utf8mb4'

 

 

 

----------------------------------------------------------------------------------------------------------------------------------------------------

 

[root@localhost dblogs]# mysql -ut1 -h10.0.0.133 -p123456 -P15002
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 72
Server version: 8.0.24-v18-txsql-2.0.1-V2.0R720D001-20210808-1715 Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> show variables like "%char%";
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
+--------------------------+---------+
7 rows in set (0.01 sec)

MySQL [(none)]> \q
Bye
[root@localhost dblogs]#