mysql出现ncorrect string value: '\xF0\x9F...' for co

发布时间：2023-06-09 13:38:39 所属栏目：MySql教程来源：

导读：1）、修改数据库的编码为utf8bm4

# vi /etc/my.cnf

[client]

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[MysqLd]

character-set-client-handshake = FALSE

1）、修改数据库的编码为utf8bm4

# vi /etc/my.cnf

[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'

重启服务

systemctl restart MysqLd.service

2）、修改数据表的编码为utf8bm4

MysqL> ALTER DATABASE voice_reports_test CHaraCTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MysqL> ALTER TABLE ZSCC_WRK_BSE_CKLCC CONVERT to CHaraCTER SET utf8mb4 COLLATE utf8mb4_bin;

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

+--------------------------+--------------------+

| 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 | utf8 |

| collation_connection | utf8mb4_unicode_ci |

| collation_database | utf8mb4_unicode_ci |

| collation_server | utf8mb4_unicode_ci |

+--------------------------+--------------------+

10 rows in set (0.00 sec)

3）、修改连接数据库的连接代码

（编辑：驾考网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!