Convert HEX to CHAR

by | Nov 13, 2007

If you want to convert a 2 digit hex code to a single char code, here is the function that you can use.

DROP FUNCTION HEX2CHAR;
CREATE FUNCTION HEX2CHAR (hexcode varchar(2))
  RETURNS CHAR(1)
  SPECIFIC hex2char
  LANGUAGE SQL
  CONTAINS SQL
  EXTERNAL ACTION
  DETERMINISTIC
  RETURN CHR((LOCATE(SUBSTR(UCASE(CHAR(RIGHT(REPEAT('0',2)||hexcode,2),2)),1,1),
      '0123456789ABCDEF')-1)*16+LOCATE(SUBSTR(UCASE(CHAR(RIGHT(REPEAT('0',2)||
       hexcode,2),2)),2,1),'0123456789ABCDEF')-1);
;