MYSQL 字符集的设置（命令行模式设置character_set*）

最新推荐文章于 2021-08-15 22:01:20 发布

转载最新推荐文章于 2021-08-15 22:01:20 发布 · 1.7k 阅读

标签

#character #mysql #collation #database #variables

#server

收录于

本文介绍如何修改MySQL数据库的字符集设置，包括使用SET语句来调整客户端、连接、数据库、结果集及服务器的字符集，并提供了将字符集从gbk更改为big5的具体示例。

SET character_set_client = gbk ;
SET character_set_connection = gbk ;
SET character_set_database = gbk ;
SET character_set_results = gbk ;
SET character_set_server = gbk ;

SET collation_connection = gbk_bin ;
SET collation_database = gbk_bin ;
SET collation_server = gbk_bin ;

update props$ set value$ = 'GB2312' where name = 'NLS_CHARACTERSET';

show variables like "%char%";
show variables like "%coll%";能看到你的mysql字符集设置，设置都改成big5试试
如：
SET character_set_client = big5
SET character_set_connection = big5
SET character_set_database = big5
SET character_set_results = big5
SET character_set_server = big5

SET collation_connection = big5
SET collation_database = big5
SET collation_server = big5