Re: "Incorrect String" error; have utf8 everywhere
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
Subject
Views
Written By
Posted
4542
August 27, 2009 02:44PM
Re: "Incorrect String" error; have utf8 everywhere
2800
August 28, 2009 12:59PM
2716
August 31, 2009 09:06AM
3632
August 31, 2009 09:28AM
2871
August 31, 2009 10:21AM
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.