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
Re: howto convert BLOB to char and COLLATE to UTF8
21670
August 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.