如何将16进制转换成字符或者整形数据 (DBMR2801)
你可以使用CAST函数将hex转换为char,用BINTOINT 函数将hex转换为integer 数据类型.此外,从2016/02/23之后提供的版本开始支持BINTOINT函数.
例子:
dmSQL> select cast('6162'x as char(2));
CAST('6162'X AS CHAR(2))
========================
ab
dmSQL> select cast('ab' as binary(2));
CAST('AB' AS BINARY(2))
=======================
6162
dmSQL>CREATE FUNCTION strtoint.BINTOINT(BINARY(8)) RETURNS BIGINT;
dmSQL>select bintoint('07DF'x);
BINTOINT('07DF'X)
====================
2015
版本: 5.3.3, 5.4.1
Product: Normal/Bundle
平台: Windows/Linux