Re: Encoding Problems (MS SQL -> MySQL)

[Miquel Angel Castillo]

Hi Pat!

I have exact the same problem to migrate the data between MS SQL and MySQL. I will solve this customizing the jdbc connection string, adding useUnicode param in both connections (MSSQL and MySQL).

It is in the first step, when select the source and target database, in Advanced >> option. I use the next jdbc connection string for MSSQL:

jdbc:jtds:sqlserver://server:1433/database;user=user;password=password;useUnicode=true;domain=

And the next one for MySQL:

jdbc:mysql://server:3306/?user=user&password=password&useServerPrepStmts=false&useUnicode=true

Replace with your database servers information, and try it ;)

P.D: Finally in the Object Mapping step I use the option multilanguage for the MySQL Schema and tables, for use utf-8 charsets in the target database.