2. -- 通过插入特殊字符的unicode编码来显示
    3. -- 特殊符号的对应编码 http://www.jsons.cn/unicode/上查询
    5. -- 系统字符集
    6. [oracle@orcl ~]$ env|grep LANG
    7. LANG=en_US.UTF-8
    8. [oracle@orcl ~]$ export NLS_LANG=american_america.AL32UTF8
    10. -- 数据库字符集
    11. SQL> select userenv('language') from dual;
    13. USERENV('LANGUAGE')
    14. ----------------------------------------------------
    15. AMERICAN_AMERICA.AL32UTF8
    17. SQL> create table tab1 (a varchar2(10));
    19. Table created.
    21. SQL> insert into tab1 values(cast(unistr('\2122') as nvarchar2(6)) );
    23. 1 row created.
    25. SQL> select * from tab1;
    27. A
    28. ----------
    29. ™
    31. SQL> insert into tab1 values(cast(unistr('\0026') as nvarchar2(6)));
    33. 1 row created.
    35. SQL> select * from tab1;
    37. A
    38. ----------
    39. ™
    40. &

    image.png