MT 2019/02/15 15:29:43
Mysql插入emoj表情
My.ini放在C:\ProgramData\MySQL\MySQL Server 5.7
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
执行sql语句(注:放最下边要不服务不能打开)
set character_set_client = utf8mb4;
set character_set_connection = utf8mb4;
set character_set_database = utf8mb4;
set character_set_results = utf8mb4;
执行语句查看utf8
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
Mysql插入emoj表情
最新推荐文章于 2022-03-22 20:01:31 发布