Monday, February 2, 2015

Is a BLOB converted using the current/default charset in MySQL?


Blob data used MySQL charset which is in my.ini

default-character-set=latin1

Suppose
  1. I have a table with a BLOB field.
  2. The charset of the table is UTF-8.
  3. I connect to the DB and "SET CHARACTER SET utf8".
  4. Then I save binary data into the field.
  5. Then I retrieve the data, and it's not what I saved (corrupt).
Because while retrieving data blob data used mysql default charset set.

Ref :
http://stackoverflow.com/questions/14734812/is-a-blob-converted-using-the-current-default-charset-in-mysql

No comments:

Post a Comment

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...