HEX to CHARACTER conversion
458415Oct 12 2005 — edited Oct 12 2005Imagine that I have a raw format variable t raw(10); and it represents a character string in binary format. Now, I want to convert it from hexadecimal RAW format to VARCHAR2. How to do that? You would say:"It's simple, just use DUMP function and cut the information header.", but the main problem is, that the variable t is a representation of string in an actual charset. So I will ask again. How to convert HEX raw representation of a string to VARCHAR2 string with a charset I like? My problem was, that some of the central european characters were damaged and split into 2 ascii characters.