MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Why does changing the collation affects how binary data is stored?
Posted by: Rick James
Date: October 06, 2009 08:33PM

The client should be at least as new as the server. (But I don't think that is the problem here.)

When the client connects, it needs to tell the server what character set (latin1 / utf8 / etc.; collation is irrelevant). The server assumes that the bytes it receives are in that charset. Then it looks at the charset for the column where you are inserting, and does a conversion if necessary. If you are inserting into a BLOB, no conversion is done.

Hmmm... I guess I don't know why it failed. :(

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Why does changing the collation affects how binary data is stored?
4329
Claude Quézel
October 05, 2009 12:09PM
Re: Why does changing the collation affects how binary data is stored?
2469
Rick James
October 06, 2009 08:33PM


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.