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

Comments

Popular posts from this blog

Changing the Java VM Memory Limits in Pentaho BI

error in pentaho 5.0.1 - authentication via url parameters for iframe

CAS with Pentaho Community Edition