Question

oracle中,如何用plsql将数字5529转换成unicode字符 ‘天’ ？

这里的5529是指16进制数字。我主要是想知道oracle有类似的函数没有？

若以下回答无法解决问题，邀请你更新回答

Answer 1

chr函数可以帮助你

追问

我看了官方文档，chr函数貌似只支持ASCII字符。

追答

ORALCE官方文档如是说：
For multibyte character sets, this sort of concatenation gives different results. For
example, given a multibyte character whose hexadecimal value is a1a2 (a1
representing the first byte and a2 the second byte), you must specify for n the decimal
equivalent of 'a1a2', or 41378:
SELECT CHR(41378) FROM DUAL;
You cannot specify the decimal equivalent of a1 concatenated with the decimal
equivalent of a2, as in the following example:
SELECT CHR(161)||CHR(162) FROM DUAL;
However, you can concatenate whole multibyte code points, as in the following
example, which concatenates the multibyte characters whose hexadecimal values are
a1a2 and a1a3:
SELECT CHR(41378)||CHR(41379) FROM DUAL;