Mysql服务器不支持4字节编码的utf8字符 [英] Mysql server does not support 4-byte encoded utf8 characters
问题描述
我从Sql Server运行数据传输组件到MySql db时收到服务器错误。
错误信息如下:
I've received a server error running a Data transfer component from Sql Server to MySql db. The error message reads as follows:
[MySql] [ODBC 5.1 Driver] [mysqld-5.0.67 -community-nt-log]服务器不支持4字节编码的UTF8字符。
源Sql Server表包含nvarchar列,目标MySql表包含varchar列。
The source Sql Server table contains nvarchar columns, the target MySql table contains varchar columns.
任何人都可以解释这个问题吗?
Can anybody shed some light on this problem?
推荐答案
你需要MySQL支持4字节的UTF-8字符(这通常被认为是UTF-8的一部分),你需要使用字符集utf8mb4,而不是utf8。 utf8mb4是在MySQL 5.5.3中首次支持。
If you need MySQL to support 4-byte UTF-8 characters (which is normally considered part of UTF-8), you need to use the character set utf8mb4, not utf8. utf8mb4 was first supported in MySQL 5.5.3.
这篇关于Mysql服务器不支持4字节编码的utf8字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!