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); ;