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'