MySQL Forums
Forum List  »  Newbie

Re: load data character set question
Posted by: Rick James
Date: March 29, 2009 08:23PM

It's a bit complicated:
character_set_client specifies what charset you are coming from. I don't recognize E2A2...; what charset is the incoming data?

Probably character_set_connection should be set to the same value as ..._client.

Those should not care what the column(s) are defined to be, MySQL will convert, if necessary.

http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

You should not be setting character_set_database, according to
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_character_set_database

Don't worry about defaults for the database, etc.

Options: ReplyQuote


Subject
Written By
Posted
March 28, 2009 02:19PM
Re: load data character set question
March 29, 2009 08:23PM


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.