2

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

buzibuzi
  • 724
  • 3
  • 15
  • 27
  • 1
    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 Dec 14 '14 at 12:40
  • yes @feeela the solution was to edit the my.ini file with the correct encoding.thanks for pointing the direction. – buzibuzi Dec 14 '14 at 15:56

1 Answers1

2

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

Community
  • 1
  • 1
buzibuzi
  • 724
  • 3
  • 15
  • 27