MySQL Forums :: Microsoft SQL Server :: Migration Errors
Migration Errors
Posted by: Dave Cordes ()
Date: January 24, 2007 10:53PM
Hey everyone,
I need some assistance converting a SQL Server 2000 database to MySQL 5.1. I am trying to use the Migration Toolkit but every time I get a bunch of errors on some of my tables that I can't seem to understand. Here are some of the errors.
Incorrect string value: '\xEF\xBF\xBD Mo...' for column 'ORDER_NOTES' at row 2
Incorrect string value: '\xEF\xBF\xBDzqu...' for column 'ORDER_NAME_LAST' at row 206
Incorrect string value: '\xEF\xBF\xBD, a...' for column 'PRODUCT_DESC' at row 10
I assume they have to do with special characters in the columns but I don't know what to do about it. I am using the default MSSQL conversion routine. Any idea?
I need some assistance converting a SQL Server 2000 database to MySQL 5.1. I am trying to use the Migration Toolkit but every time I get a bunch of errors on some of my tables that I can't seem to understand. Here are some of the errors.
Incorrect string value: '\xEF\xBF\xBD Mo...' for column 'ORDER_NOTES' at row 2
Incorrect string value: '\xEF\xBF\xBDzqu...' for column 'ORDER_NAME_LAST' at row 206
Incorrect string value: '\xEF\xBF\xBD, a...' for column 'PRODUCT_DESC' at row 10
I assume they have to do with special characters in the columns but I don't know what to do about it. I am using the default MSSQL conversion routine. Any idea?
| Subject | Written By | Posted |
|---|---|---|
| Migration Errors | Dave Cordes | 01/24/2007 10:53PM |
| Re: Migration Errors | Jason Rider | 06/11/2007 09:03AM |
| Re: Migration Errors | Jonathan Mischo | 06/14/2007 01:09PM |
| Re: Migration Errors .. Solution is here.. | Bipin Kadam | 10/25/2007 06:40AM |
| Re: Migration Errors - Solution | Garrett Williams | 01/10/2008 12:33PM |
| Re: Migration Errors - Solution | Daniel Galan | 02/20/2008 05:23PM |
| Re: Migration Errors - Solution | Marc M | 05/29/2008 06:27PM |
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.
© 2013, Oracle Corporation and/or its affiliates