本文主要是介绍mysql 插入微信名有特殊字符的问题,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
失败sql
insert into user(uuid,name,wxopenid,img)
values(uuid(),'CAIDEWI🔰','oJPUI55T4bTGGlWKCiPwDbgrTpoE',
'https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoQR0OdOKqXbQTHr0siaTD4wia2qsWzkYANcPvspUPvbygp0DZbIRYe6Ng1oGR4PGUlEAbjiaVt5Uh0g/132')
解决方案
1、
ALTER DATABASE dianshang CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table user change name name varchar(191) character set utf8mb4 collate utf8mb4_unicode_ci
2、 修改my.cnf linux的文件在etc下
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
datadir=/usr/local/mysql/data
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8mb4
character-set-client-handshake = FALSE
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
这篇关于mysql 插入微信名有特殊字符的问题的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!