CODEWITHSUNDEEP
mysqlsql-servermysql-workbenchdatabase-migrationutf8mb4
David Young
David Young

Reputation: 31

MYSQL Workbench "Incorrect string value" error while migrating database from MS SQL-Server

I am trying to migrate a SQL-Server database to MYSQL. I am getting the error

"Incorrect string value: '\xF0\x9F\x98\x8B\xF0\x9F...'"

I am using the batch file created by MySQL Workbench 8.0 CE to see the error because the UI crashes and freezes.

The source table is in Latin1_General_CI_AS

The destination table has been created as utf8mb4_0900_ai_ci

Source database: Mssql@DRIVER=ODBC Driver 17 for SQL Server;SERVER=localhost\SQLEXPRESS (Microsoft SQL Server)

Target database: Mysql@localhost:3306

Is there anything else I can try?

Upvotes: 2

Views: 829

Answers (1)

Rick James
Rick James

Reputation: 142298

That hex is not Latin1, nor UTF16; it matches the UTF-8 encoding for 😋. (That's the first 4 bytes; the next two are probably the beginning of another Emoji.)

The connection parameters need to say that the data is encoded utf8mb4. It is not sufficient to specify the table to be utf8mb4.

The source table was not Latin1. Or you did not notice that that Emoji displayed as this Mojibake: 😋.

Upvotes: 1

Related Questions