Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: howto convert BLOB to char and COLLATE to UTF8


Advanced Search

Re: howto convert BLOB to char and COLLATE to UTF8
Posted by: KimSeong Loh ()
Date: August 16, 2007 12:35AM

Is your BLOB stored as utf8 byte values? or other character set?
CAST(a.ar_options AS CHAR(10000) CHARACTER SET utf8)
You have to specify the correct character set above, depending what the BLOB is storing. Does it store the umlat in utf8 encoding? If it is then it should work. If it is stored as latin1, then you have to specify latin1 charset in the cast.

Options: ReplyQuote


Subject Views Written By Posted
howto convert BLOB to char and COLLATE to UTF8 17523 Ragnar Heil 07/30/2007 08:17AM
Re: howto convert BLOB to char and COLLATE to UTF8 12135 KimSeong Loh 08/16/2007 12:35AM


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.