YashanDB HEXTORAW函数

hextoraw::= HEXTORAW "(" expr ")"

SELECT HEXTORAW('1234abcd') res FROM DUAL;
RES
-------------------- 
1234ABCD

SELECT HEXTORAW('') res FROM DUAL;
RES
-------------- 
              
--包含不属于十六进制表述范围（0-9、a-f、A-F）的字符时报错
SELECT HEXTORAW('1234abcddfdfh') res FROM DUAL;
YAS-00223 invalid hex number

--奇数位在前面补0
SELECT HEXTORAW('1abcdef') res FROM DUAL;
RES
--------
01ABCDEF

--超过RAW列宽度的2倍时报错
CREATE TABLE tb_raw(c1 RAW(4));
INSERT INTO tb_raw VALUES('abcdabcd');
INSERT INTO tb_raw VALUES('abcdabcda');
YAS-04008 C1 size exceeding limit 4