Regarding the error - 'incorrect string value ' while migrating data from ingres to MYSQL 5.2
Posted by: Satya Kalimili
Date: May 13, 2009 11:11AM

Getting the incorrect string value while migrating from ingres to MYSQL 5.2

We have changed the collation and character set on fields of certain tables to UTF8 and utf8_general_ci and it has worked.

There is still one table giving the error 'incorrect string' on a single field - changing the collation and char set to UTF8 is not resolving the problem.

a) how could this be resolved...please advice

b) Is it advisable to change all the tables and text fields in a database to UTF8


Thanks



Edited 1 time(s). Last edit at 05/13/2009 11:13AM by Satya Kalimili.

Options: ReplyQuote


Subject
Written By
Posted
Regarding the error - 'incorrect string value ' while migrating data from ingres to MYSQL 5.2
May 13, 2009 11:11AM


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.