MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Problem with Accented characters while migrating SQL server to MySql server
Posted by: Francis Guay
Date: August 29, 2014 09:22AM

Hi I had started to Migrate an old website SQL server database to MySql because we are changing server soon.

The migrate work almost perfectly, except one thing. All data with accented character has been truncated.

My Sql server database was all in SQL_Latin1_General_CP1_CI_AS and we convert the mysql database in latin1 - default collation, but it didn't work, same thing with utf8_general_ci encoding.


Source: Microsoft SQL Server 9.0.3042

Target: MySQL 5.1.56

If you can help me I would really apreciate it!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Problem with Accented characters while migrating SQL server to MySql server
Francis Guay
August 29, 2014 09:22AM
Re: Problem with Accented characters while migrating SQL server to MySql server
Rick James
August 31, 2014 11:02AM


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.