character set problem
Posted by: Zsolt Somogyi
Date: November 26, 2015 05:07AM


I have an issue with MS SQL to MySQL migration.
The database migration is OK, but in the database the words with hungarian accented character are truncated. After many attempts I tried it with collation latin2_hungarian_ci (during manual mapping objects of migration) and the result was that the words no truncate but instead of accented character I have got "?". For example the right word is: kövirózsa but i get k?vir?zsa.
I have tried to set names of database latin2 with no result. The default was utf8.

I have MSSQL2008 with database collation SQL_Hungarian_CP1250_CI_AS
MySQL Workbench newest wersion: 6.3.5
MySQL version: 5.5.39
I use connection method: ODBC Data Source (Free TDS). (Without free TDS the migration stops with errors)

I have been trying it for days with bunch of possibility but no success... And our project stopped because it. Please help me. Many thanks.

Options: ReplyQuote

Written By
character set problem
November 26, 2015 05:07AM
November 29, 2015 11:19AM
December 09, 2015 05:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.