Export from SQL Server to MySQL encoding issue

Question

I have a MS-SQL server 2012 Express database with Hebrew_CI_AS collation.

Im using MySQL Migration Toolkit to migrate the database to a MySql server.

The migration completes succefully but in the MySql the Hebrew strings show up as question marks ???

During the migration this notice shows up:

"Collation Hebrew_CI_AS migrated to utf8_general_ci"

I looked in the the MySql database and tables and they actually have latin1_swedish_ci collation when created by the migration tool.

I tried to solve it by converting the MySql DB and tables to utf8_general_ci just before the Migration tool copies the data from SQL to MySql but this didn't help. tried this also with Hebrew_general_ci but it had the same result.

Any ideas how to copy the data with the Hebrew strings intact ?

Thanks

Setting the target tables and columns to an encoding of Hebrew_general_ci before the import should solve the problem. Maybe you need to set the connection encoding via some configuration in the "MySQL Migration Toolkit". — feeela
– feeela, Commented Dec 14, 2014 at 12:40
yes @feeela the solution was to edit the my.ini file with the correct encoding.thanks for pointing the direction. — buzibuzi
– buzibuzi, Commented Dec 14, 2014 at 15:56

Community · Accepted Answer · 2017-05-23 11:45:18Z

1

So the solution was to edit the my.ini mysql configuration file as described here

with

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

that worked for me,

Hebrew is now showing

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Dec 14, 2014 at 15:58

buzibuzi

7243 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export from SQL Server to MySQL encoding issue

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related