Re: "Incorrect String" error; have utf8 everywhere
Posted by: Peter Gulutzan
Date: August 28, 2009 12:59PM

1. Things like "DB charset" are only defaults. To prove that the column
you're inserting into really is UTF8, look at character_set_name in
information_schema.columns.

2. The character that's failing is A-with-ring. The encoding for that should be
C385. Try inserting it directly:
"INSERT INTO table_name (column_name) VALUES (0xc385);".
Then make sure that c385 is what's in the file.
If the file turns out to be non-UTF8, you might benefit from using
LOAD DATA INFILE's CHARACTER SET clause, which has been available
since version 5.1.17.

Peter Gulutzan
Sun Microsystems / MySQL

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: "Incorrect String" error; have utf8 everywhere
2800
August 28, 2009 12:59PM


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.