• Oracle字符集


    select nls_charset_name(to_number('0352','xxxx')) from dual;--ZHS16CGB231280
    select nls_charset_name(to_number('0353','xxxx')) from dual;--ZHS16MACCGB231280
    select nls_charset_name(to_number('0354','xxxx')) from dual;--ZHS16GBK
    select number1,characterset1 from ( select lpad(to_char( level),4,'0') number1,nls_charset_name(to_number(lpad(to_char( level),4,'0'),'xxxx')) characterset1 from dual connect by level<10000 ) where characterset1 is not null

    Oracle中的字符集,如下图

    0366AL24UTFFSS0369AL32UTF80235AR8ARABICMAC0236AR8ARABICMACS0237AR8ARABICMACT0140AR8EBCDIC420S0046AR8EBCDICX0202AR8HPARABIC8T0024AR8ISO8859P60230AR8MSWIN12560231AR8NAFITHA7210233AR8SAKHR7060048AR8XBASIC0034AZ8ISO8859P9E0186CDN8PC8630030CEL8ISO8859P140013CH7DEC0142CL8EBCDIC1025C0143CL8EBCDIC1025R0145CL8EBCDIC11580146CL8EBCDIC1158R0023CL8ISO8859P50031CL8ISOIR1110033CL8KOI8U0020EE8ISO8859P20106EE8MACCE0107EE8MACCROATIAN0096EE8PC8520071EEC8EUROPA30051EL8DEC0147EL8EBCDIC423R0144EL8EBCDIC875R0137EL8EBCDIC875S0025EL8ISO8859P70182EL8PC8510181EL8PC8690191HU8ABMOD0170HU8CWI20011I7DEC0019IN8ISCII0109IS8MACICELANDIC0017IW7IS9600026IW8ISO8859P80341JA16DBCS0729JA16DBCSFIXED0343JA16EBCDIC9300726JA16EUCFIXED0345JA16EUCTILDE0344JA16MACSJIS0340JA16SJIS0728JA16SJISFIXED0346JA16SJISTILDE0342JA16SJISYEN0732KO16DBCSFIXED0348KO16KSC56010730KO16KSC5601FIXED0072LA8PASSPORT0180LT8PC7740010NDK7DEC0028NE8ISO8859P100022NEE8ISO8859P40012NL7DEC0099RU8BESTA0098RU8PC8660021SE8ISO8859P30015SF7DEC0161TH8MACTHAI0162TH8MACTHAIS0029TH8TISASCII0016TR7DEC0052TR8DEC0138TR8EBCDIC1026S0108TR8MACTURKISH0001US7ASCII0115US8ICL0004US8PC4370367UTF80368UTFE0002WE8DEC0060WE8EBCDIC10470064WE8EBCDIC1047E0007WE8EBCDIC11400061WE8EBCDIC1140C0062WE8EBCDIC11450009WE8EBCDIC11460063WE8EBCDIC1148C0008WE8EBCDIC2850005WE8EBCDIC370006WE8EBCDIC5000065WE8EBCDIC9240003WE8HP0116WE8ICL0027WE8ISO8859P90117WE8ISOICLUK0160WE8MACROMAN8S0032WE8NEXTSTEP0105WE8ROMAN80014YUG7ASCII0352ZHS16CGB2312800355ZHS16DBCS0354ZHS16GBK0353ZHS16MACCGB2312800356ZHS32GB180300361ZHT16BIG50749ZHT16BIG5FIXED0362ZHT16CCDC0360ZHT16DBCS0748ZHT16DBCSFIXED0364ZHT16HKSCS0363ZHT16MSWIN9500744ZHT32EUCFIXED0747ZHT32TRISFIXED

  • 相关阅读:
    .Net Web开发技术栈
    C#foreach原理
    C#位运算符
    python写12306抢票
    java语法学习
    建立个人知识体系
    struts2静态方法和动态方法调用
    springmvc跳转的几种方式
    JDBC驱动程序的四种方式
    eclipse用axis2发布webserver
  • 原文地址:https://www.cnblogs.com/adamgq/p/13807850.html
Copyright © 2020-2023  润新知