mysql存储emoji表情报错问题
2023-09-14 08:59:53 时间
emoji
表情使用mysql的默认字符设置UTF-8会报错:
Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xE6\x88\x91\xE4\xBB\xAC...' for column 'xx' at row 1
这种原因是字符集编码导致的。
1、验证字符集
首先进入mysql:
mysql -u root -p
进入之后输入以下:
show variables like '%character%';
这里是输入命令之后的视图:
mysql> show variables like '%character%';
+--------------------------+--------------------------------------------------------+
| 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 |
| character_sets_dir | /usr/local/mysql-8.0.29-macos12-x86_64/share/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.01 sec)
2、进入my.cnf
vim /etc/my.cnf
编辑my.cnf
[client]
default-character-set=utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
skip-character-set-client-handshake = true
[mysql]
default-character-set = utf8mb4
重启数据库服务即可正常存储表情符号,当前版本是: mysql Ver 8.0.29 for macos12 on x86_64 (MySQL Community Server - GPL)
相关文章
- MySql存储过程
- Mysql授权允许远程访问解决Navicat for MySQL连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
- 【Mysql 学习】mysqld_safe:MySQL服务器启动脚本
- 【华为云技术分享】使用sqoop导入mysql数据到hive中
- mac mysql 修改密码
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)
- MySQL存储过程实现动态执行SQL
- Python MySQLdb模块连接操作mysql数据库实例_python
- Java通过mysql-connector-java-8.0.11连接MySQL Server 8.0遇到的几个问题
- MySQL事务隔离级别,锁(转)
- MYSQL错误解决:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- MYSQL的用户变量(@)和系统变量(@@)
- MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误
- MySQL的锁机制和加锁原理
- MySQL数据类型详解
- [转]2006 MySQL server has gone away错误,最大值溢出解决办法 mysql max_allowed_packet 查询和修改
- [转]MySQL事务学习-->隔离级别
- mysql存储图片_Python
- 【高可用MySQL解决方案】centos7配置mysql主从复制
- MySQL 连接为什么挂死了?
- [手游项目2]-15-单引号导致mysql存储失败问题
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错:2006 - MySQL server has gone away
- mySQl该数据库不能将中国的做法
- |ERROR|ERROR: missing data for column "createtime" (seg3 slice1 192.168.66.23:40001 pid=33370)之mysql换行符或者空格引起的问题
- mysql-connector-java与Mysql、Java的对应版本
- MySQL-小章节-InnoDB存储引擎核心特性-参数补充