MySQL Forums
Forum List  »  Newbie

can't import mysql file
Posted by: rolly4444 AM
Date: July 23, 2015 05:08AM

when i attemp to import afile called world-mysql.sql i get the following message
ERROR 1366 (HY000) at line 96: Incorrect string value: '\xD9\x8Erdob...' for column 'Name' at row 1
when i checked the mentioned line i found some special characters like ’ “ ” ì ‘ ' … è ä ó ú í é, then i removed them but i don't think this right and they are to many.

then i got another message ERROR 1406 (22001) at line 77: Data too long for column

who can i overcome these two problems

Options: ReplyQuote


Subject
Written By
Posted
can't import mysql file
July 23, 2015 05:08AM
August 01, 2015 11:34PM


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.