Re: load data character set question

[Rick James]

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.