Re: howto convert BLOB to char and COLLATE to UTF8
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.
Subject
Views
Written By
Posted
24401
July 30, 2007 08:17AM
Re: howto convert BLOB to char and COLLATE to UTF8
21958
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.