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.
Subject
Written By
Posted
MS Sql to MySQL migration - data transfer issue
December 15, 2015 01:36PM
December 16, 2015 04:50PM
December 17, 2015 10:46AM
February 04, 2016 12:27PM
February 10, 2016 05:42AM
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.