OracleUTL_ENCODE字符集编码和转码_跳跃生命线

个人资料

微博

正文字体大小：大中小

OracleUTL_ENCODE字符集编码和转码

(2023-02-10 13:47:09)

标签：

分类：技术类

Oracle UTL_ENCODE 字符集编码和转码

Common character sets include:

US7ASCII: US 7-bit ASCII character set

WE8DEC: West European 8-bit character set

F7DEC: DEC French 7-bit character set

WE8EBCDIC500: IBM West European EBCDIC Code Page 500

WE8ISO8859P1: ISO 8859-1 West European 8-bit character set

UTF8: Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant

AL32UTF8: Unicode 3.1 UTF-8 Universal character set

-- 编码过程

SELECT CONVERT('刘轶鹤', 'US7ASCII') AS US7ASCII_CN

,CONVERT('liuyihe', 'US7ASCII') AS US7ASCII_EN

,REPLACE(REPLACE(UTL_ENCODE.TEXT_ENCODE('刘轶鹤', 'AL32UTF8',1), CHR(13), NULL), CHR(10), NULL) AS AL32UTF8_CN

,REPLACE(REPLACE(UTL_ENCODE.TEXT_ENCODE('liuyihe', 'AL32UTF8',1), CHR(13), NULL), CHR(10), NULL) AS AL32UTF8_EN

from dual

;

编码过程结果

-- 解码过程

SELECT REPLACE(REPLACE(UTL_ENCODE.TEXT_DECODE('5YiY6L226bmk', 'AL32UTF8',1), CHR(13), NULL), CHR(10), NULL) AS AL32UTF8_CN_DE

,REPLACE(REPLACE(UTL_ENCODE.TEXT_DECODE('bGl1eWloZQ==', 'AL32UTF8',1), CHR(13), NULL), CHR(10), NULL) AS AL32UTF8_EN_DE

FROM dual;

解码过程结果

-- 刘轶鹤

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report