Incorrect string value ; unicode problem?
Posted by: MySQL User
Date: January 01, 2009 06:29PM

I'm importing a Wikipedia dump of the file pagelinks.sql. When I do the import, I'm getting an error saying:

ERROR 1366 (HY000): Incorrect string value: '\xBD_char...' for column 'pl_title'

The offending line is:

582,0,'Ranma_½_characters'

I assume that the ½ must be the problem. Is this a unicode problem? I created the database as utf8. What should I do? I am using MySQL 5.1.30 on Vista64.

Options: ReplyQuote


Subject
Views
Written By
Posted
Incorrect string value ; unicode problem?
6875
January 01, 2009 06:29PM


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.