oracle支持字符集名称:
SQL> select value from V$NLS_VALID_VALUES where parameter='CHARACTERSET' order by value;
......
242 rows selected.
将名称转换成十六进制:
SQL> SELECT to_char(NLS_CHARSET_ID('ZHS16GBK'),'xxxx') as "HexId" from dual;
HexId
-----
354
SQL>
SQL> select value from V$NLS_VALID_VALUES where parameter='CHARACTERSET' order by value;
......
242 rows selected.
将名称转换成十六进制:
SQL> SELECT to_char(NLS_CHARSET_ID('ZHS16GBK'),'xxxx') as "HexId" from dual;
HexId
-----
354
SQL>