Logo Questions Linux Laravel Mysql Ubuntu Git Menu

Mysql server does not support 4-byte encoded utf8 characters

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]Server does not support 4-byte encoded UTF8 characters.

The source Sql Server table contains nvarchar columns, the target MySql table contains varchar columns.

Can anybody shed some light on this problem?

like image 553
YB. Avatar asked Dec 18 '22 04:12


1 Answers

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.

like image 91
prosfilaes Avatar answered Jan 05 '23 15:01