select ascii('码') from dual
select chr(49899) from dual;
select substr('D6D0',1,4) from dual;
select to_char(ascii(substr('码',1,1)),'XXXX') from dual;
select chr(to_number(substr('C2EB',1,4),'XXXX')) from dual;
select chr(49899) from dual;
select substr('D6D0',1,4) from dual;
select to_char(ascii(substr('码',1,1)),'XXXX') from dual;
select chr(to_number(substr('C2EB',1,4),'XXXX')) from dual;
本文通过几个SQL查询示例展示了如何进行字符编码之间的转换,包括ASCII码的查询、十六进制到字符的转换以及字符串子串的提取等操作。
2万+

被折叠的 条评论
为什么被折叠?



