CODEWITHSUNDEEP
mysqlsql-server
buzibuzi
buzibuzi

Reputation: 734

Export from SQL Server to MySQL encoding issue

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

Upvotes: 2

Views: 1318

Answers (1)

buzibuzi
buzibuzi

Reputation: 734

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

Upvotes: 2

Related Questions