MySQL Forums
Forum List  »  Microsoft SQL Server

Problems with utf8 characters when migrating from SQL Expres 2008
Posted by: morten nielsen
Date: November 13, 2012 10:36PM

Hi

I have a problem when trying to migrate a database from MS Express 2008 to MySql 5.5.

I use the migration-tool in MySql Workbench (newest version) and all the schema creation and mapping is working perfectly. But when it comes to bulk-copy, the data inserted is not converted to utf8, and that results in strings that are "cut off" when a danish Æ-Ø-Å is encountered.

When i run the wizard and it comes to "Manual Editing" it says under "Migration Message": Collation Danish_Norwegian_CI_AS migrated to utf8_general_ci. SO i dont understand, why it is not working?

I have tried the migration-tool in SQLyog, and it handles the conversion as expected, but i really dont want to pay for it :)

How can i make it convert the strings correctly?

Some help or guidance would be really helpfull.

Regards, Morten

Options: ReplyQuote




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.