Casting from Hex to char
564035Oct 20 2007 — edited Oct 20 2007Hi,
I have a variable with the following hex characters:
3c61746167313e0ac7cde3cf20c7e1dac8cf0a3c2f61746167313e
which is in fact an arabic character converted from charcter set 1256.
I need to change it back to proper Arabic character but its mixing up some of the letters.
I did as follows:
select utl_raw.cast_to_varchar2('3c61746167313e0ac7cde3cf20c7e1dac8cf0a3c2f61746167313e') from dual;
it mixes up some letters.
Can we specify a character set when casting hex?
I mean if the hex representation was from character set 1256 (in windows) , and the oracle client recieves 8859P6 characterset, how can we make it compatible?
regards
Abdullah