MySQL Forums
Forum List  »  Microsoft SQL Server

MS Sql to MySQL migration - data transfer issue
Posted by: Vinny K
Date: December 15, 2015 01:36PM

Migration from MS sql 2008.
workbench 6.3.5

Migration is failing when I am using different characters like (ã). Manual insert in to the table is working. But workbench is not able to convert it properly.In the insert statement created by workbenck those characters are being replaced by question mark and the copy is failing with this error :

14:26:05 [INF][ copytable]: Statement execution failed: Incorrect string value: '\xE3h' for column 'Type':

INSERT INTO `TestDB`.`Person` (`Name`, `Age`, `Type`) VALUES '(Peter ',35,'The Peet\�h')

Type should be 'The Peetãh'

I am using ODBC Data source(Free TDS) Connection method with Native 10.0 driver
Latin1 to UTF8.

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.