MySQL Forums :: Newbie :: Problem with Accented characters while migrating SQL server to MySql server


Advanced Search

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!

Options: ReplyQuote


Subject Written By Posted
Problem with Accented characters while migrating SQL server to MySql server Francis Guay 08/29/2014 09:22AM
Re: Problem with Accented characters while migrating SQL server to MySql server Rick James 08/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.