hex to char conversion

Database
Enthusiast

hex to char conversion

Hi,

Could anyone help me to convert HEX to CHAR for given column. I knew we can pass the hex value and convert to char, here I want to pass the column name (e.g: CHAR_To_HEX) and get char value.

--this works

SEL

CHAR2HEXINT('2650Wilson Ave.') AS CHAR_To_HEX

_UNICODE '003200360035003000570069006C0073006F006E0020004100760065002E'XCV AS HEX_TO_CHAR

;

--this error out

SEL

CHAR2HEXINT('2650Wilson Ave.') AS CHAR_To_HEX

_UNICODE (CHAR_To_HEX)'XCV AS HEX_TO_CHAR

;

Tags (1)
1 REPLY
Enthusiast

Re: hex to char conversion

Hello ,

Just wondering, if you got a resolution as I am facing the same problem now.

Thanks

Abhishek