`
kumcun
  • 浏览: 89252 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

Oracle中NLS_LANG的默认值

OracleMicrosoftWindowsIBMIE 
阅读更多

Table 4 NLS_LANG Parameter Values for Linux Locales

Language Locale ID NLS_LANG

English (American)

en_US.UTF-8

AMERICAN_AMERICA.AL32UTF8

English (American)

en_US.ISO-8859-1

AMERICAN_AMERICA.WE8ISO8859P1

English (American)

en_US.ISO-8859-15

AMERICAN_AMERICA.WE8ISO8859P15

English (Australian)

en_AU.UTF-8

ENGLISH_AUSTRALIA.AL32UTF8

English (Australian)

en_AU.ISO-8859-1

ENGLISH_AUSTRALIA.WE8ISO8859P1

English (Australian)

en_AU.ISO-8859-15

ENGLISH_AUSTRALIA.WE8ISO8859P15

English (British)

en_GB.UTF-8

ENGLISH_UNITED KINGDOM.AL32UTF8

English (British)

en_GB.ISO-8859-1

ENGLISH_UNITED KINGDOM.WE8ISO8859P1

English (British)

en_GB.ISO-8859-15

ENGLISH_UNITED KINGDOM.WE8ISO8859P15

English (Ireland)

en_IE.UTF-8

ENGLISH_IRELAND.AL32UTF8

English (Ireland)

en_IE.ISO-8859-1

ENGLISH_IRELAND.WE8ISO8859P1

English (Ireland)

en_IE.ISO-8859-15

ENGLISH_IRELAND.WE8ISO8859P15

German

de_DE.UTF-8

GERMAN_GERMANY.AL32UTF8

German

de_DE.ISO-8859-1

GERMAN_GERMANY.WE8ISO8859P1

German

de_DE.ISO-8859-15

GERMAN_GERMANY.WE8ISO8859P15

French

fr_FR.UTF-8

FRENCH_FRANCE.AL32UTF8

French

fr_FR.ISO-8859-1

FRENCH_FRANCE.WE8ISO8859P1

French

fr_FR.ISO-8859-15

FRENCH_FRANCE.WE8ISO8859P15

Italian

it_IT.UTF-8

ITALIAN_ITALY.AL32UTF8

Italian

it_IT.ISO-8859-1

ITALIAN_ITALY.WE8ISO8859P1

Italian

it_IT.ISO-8859-15

ITALIAN_ITALY.WE8ISO8859P15

Spanish

es_ES.UTF-8

SPANISH_SPAIN.AL32UTF8

Spanish

es_ES.ISO-8859-1

SPANISH_SPAIN.WE8ISO8859P1

Spanish

es_ES.ISO-8859-15

SPANISH_SPAIN.WE8ISO8859P15

Spanish (Mexico)

es_MX.UTF-8

MEXICAN SPANISH_MEXICO.AL32UTF8

Spanish (Mexico)

es_MX.ISO-8859-1

MEXICAN SPANISH_MEXICO.WE8ISO8859P1

Spanish (Mexico)

es_MX.ISO-8859-15

MEXICAN SPANISH_MEXICO.WE8ISO8859P15

Portuguese (Brazilian)

pt_BR.UTF-8

BRAZILIAN PORTUGUESE_BRAZIL.AL32UTF8

Portuguese (Brazilian)

pt_BR.ISO-8859-1

BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1

Portuguese (Brazilian)

pt_BR.ISO-8859-15

BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P15

Japanese

ja_JP.EUC-JP

JAPANESE_JAPAN.JA16EUC

Japanese

ja_JP.UTF-8

JAPANESE_JAPAN.AL32UTF8

Korean

ko_KR.EUC-KR

KOREAN_KOREA.KO16KSC5601

Korean

ko_KR.UTF-8

KOREAN_KOREA.AL32UTF8

Chinese (simplified)

zh_CN.GB18030

SIMPLIFIED CHINESE_CHINA.ZHS32GB18030

Chinese (simplified)

zh_CN.UTF-8

SIMPLIFIED CHINESE_CHINA.AL32UTF8

Chinese (traditional)

zh_TW.BIG5

TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5

Chinese (traditional)

zh_TW.UTF-8

TRADITIONAL CHINESE_TAIWAN.AL32UTF8

11.3 Supported Character Sets

Table 5 lists the supported character sets in Oracle Database XE. The list is ordered alphabetically in each language group.

The character set AL16UTF16 can be used only as an NCHAR character set, and not as a database character set.


Table 5 Supported Character Sets

Name Description

Asian

 

JA16EUC

EUC 24-bit Japanese

JA16EUCTILDE

The same as JA16EUC except for the way that the wave dash and the tilde are mapped to and from Unicode

JA16SJIS

Shift-JIS 16-bit Japanese. The same as JA16SJISTILDE except for the way that the wave dash and the tilde are mapped to and from Unicode

JA16SJISTILDE

Microsoft Windows Code Page 932 Japanese

KO16KSC5601

KSC5601 16-bit Korean

KO16MSWIN949

Microsoft Windows Code Page 949 Korean

TH8TISASCII

Thai Industrial Standard 620-2533 - ASCII 8-bit

VN8MSWIN1258

Microsoft Windows Code Page 1258 8-bit Vietnamese

ZHS16CGB231280

CGB2312-80 16-bit Simplified Chinese

ZHS16GBK

GBK 16-bit Simplified Chinese

ZHS32GB18030

GB18030-2000

ZHT16BIG5

BIG5 16-bit Traditional Chinese

ZHT16HKSCS

Microsoft Windows Code Page 950 with Hong Kong Supplementary Character Set HKSCS-2001 (character set conversion to and from Unicode is based on Unicode 3.0)

ZHT16MSWIN950

Microsoft Windows Code Page 950 Traditional Chinese

ZHT32EUC

EUC 32-bit Traditional Chinese

European

 

BLT8CP921

Latvian Standard LVS8-92(1) Windows/UNIX 8-bit Baltic

BLT8ISO8859P13

ISO 8859-13 Baltic

BLT8MSWIN1257

Microsoft Windows Code Page 1257 8-bit Baltic

BLT8PC775

IBM-PC Code Page 775 8-bit Baltic

CEL8ISO8859P14

ISO 8859-13 Celtic

CL8ISO8859P5

ISO 8859-5 Latin/Cyrillic

CL8KOI8R

RELCOM Internet Standard 8-bit Latin/Cyrillic

CL8KOI8U

KOI8 Ukrainian Cyrillic

CL8MSWIN1251

Microsoft Windows Code Page 1251 8-bit Latin/Cyrillic

EE8ISO8859P2

ISO 8859-2 East European

EL8ISO8859P7

ISO 8859-7 Latin/Greek

ET8MSWIN923

Microsoft Windows Code Page 923 8-bit Estonian

EE8MSWIN1250

Microsoft Windows Code Page 1250 8-bit East European

EL8MSWIN1253

Microsoft Windows Code Page 1253 8-bit Latin/Greek

EL8PC737

IBM-PC Code Page 737 8-bit Greek/Latin

EE8PC852

IBM-PC Code Page 852 8-bit East European

LT8MSWIN921

Microsoft Windows Code Page 921 8-bit Lithuanian

NE8ISO8859P10

ISO 8859-10 North European

NEE8ISO8859P4

ISO 8859-4 North and North-East European

RU8PC866

IBM-PC Code Page 866 8-bit Latin/Cyrillic

SE8ISO8859P3

ISO 8859-3 South European

US7ASCII

ASCII 7-bit American

US8PC437

IBM-PC Code Page 437 8-bit American

WE8ISO8859P1

ISO 8859-1 West European

WE8ISO8859P15

ISO 8859-15 West European

WE8MSWIN1252

Microsoft Windows Code Page 1252 8-bit West European

WE8PC850

IBM-PC Code Page 850 8-bit West European

WE8PC858

IBM-PC Code Page 858 8-bit West European

Middle Eastern

 

AR8ADOS720

Arabic MS-DOS 720 Server 8-bit Latin/Arabic

AR8ASMO8X

ASMO Extended 708 8-bit Latin/Arabic

AR8ISO8859P6

ISO 8859-6 Latin/Arabic

AR8MSWIN1256

Microsoft Windows Code Page 1256 8-Bit Latin/Arabic

AZ8ISO8859P9E

ISO 8859-9 Latin Azerbaijani

IW8ISO8859P8

ISO 8859-8 Latin/Hebrew

IW8MSWIN1255

Microsoft Windows Code Page 1255 8-bit Latin/Hebrew

TR8MSWIN1254

Microsoft Windows Code Page 1254 8-bit Turkish

TR8PC857

IBM-PC Code Page 857 8-bit Turkish

WE8ISO8859P9

ISO 8859-9 West European & Turkish

Universal

 

AL16UTF16

Unicode 4.0 UTF-16 Universal character set

AL32UTF8

Unicode 4.0 UTF-8 Universal character set

UTF8

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

分享到：
| [转]更改Oracle字符集：把字符集ZHS16GBK ...
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    oracle详解

    在windows中，查询和修改NLS_LANG可在注册表中进行： HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOMExx\ xx指存在多个Oracle_HOME时的系统编号。 在unix中： $ env|grep NLS_LANG NLS_LANG=simplified chinese_china.ZHS...

    Oracle_字符集的查看和修改

    在 Oracle 中，影响字符集设置的关键参数是 **NLS_LANG**。该参数由三个部分组成：**语言 (Language)**、**地域 (Territory)** 和 **字符集 (Charset)**。 1. **Language**: 指定服务器消息使用的语言，例如是否...

    linux系统安装oracle11g

    export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib ``` 保存并退出编辑器。接着需要重新登录Oracle用户...

    64系统安装oracle11g及plsql连接配置.docx

    然后在“我的电脑”属性中修改环境变量，添加NLS_LANG变量并设置相应的值。 通过以上步骤，你可以在64位Windows 7系统上成功安装Oracle 11g并配置32位PLSQL Developer进行连接。记得在使用过程中定期检查和更新...

    ORACLE完全卸载

    - `NLS_LANG`，默认值为`SIMPLIFIEDCHINESE_CHINA.ZHS16GBK`。 - `ORACLE_HOME`，默认值为`C:\app\Administrator\product\11.2.0\dbhome_1`。 - `ORACLE_SID`，默认值为`ORCL`。 - `Path`中包含`C:\app\...

    oracle Database 10g for Windows安装

    同时，检查注册表中的NLS_LANG设置，确保其符合中文环境的需求。 Oracle Database 10g的安装涉及多个层面的配置，理解这些步骤对于数据库的日常管理和维护至关重要。通过以上详述的步骤，可以成功地在Windows环境下...

    oracle的安装手册

    在这里，新建一个名为“NLS_LANG”的系统变量，值设定为“Simplified Chinese_China.ZHS16GBK”，以确保Oracle支持简体中文。 接下来是Oracle 9i PATCH的安装，通常分为三个步骤。步骤1中，运行补丁安装程序，指定...

    oracle+windows2003(64位)集群配置

    - 修改注册表路径`HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1`中的`NLS_LANG`值为`SIMPLIFIEDCHINESE_CHINA.ZHS16GBK`。 - 从32位操作系统导入数据到64位系统时,存储过程或视图中的中文可能会出现...

    oracle rman笔记

    - 默认值为7天，表示控制文件中记录的备份信息将被保留的时间长度。 - **文件集大小**（FILES_PER_SET）： - 用于指定每个备份集包含的文件数量，默认为1。 - **闪回恢复区设置**（DB_RECOVERY_FILE_DEST）： - ...

    Oracle11g安装完整步骤

    - **NLS_LANG：** 设置为`SIMPLIFIEDCHINESE_CHINA.ZHS16GBK`，以便支持中文。 - **LANG：** 设置为`zh_CN.GBK`，解决中文乱码问题。 - **ORACLE_HOME：** 指定客户端文件夹的位置，例如`D:\ProgramFiles\instant...

    oracle

    例如，`set NLS_LANG=american_america.us7ascii` 这条命令就是用来设置编码环境的。 - **恢复练习表**: 若要恢复特定的练习表，可以通过在SQLPLUS中执行特定脚本的方式来实现。例如，`sqlplus /*password*/ @...

    Oracle文件导入导出

    为了使`exp`的帮助文档以不同字符集显示，可以通过设置环境变量`NLS_LANG`来实现。例如，设置为`simplifiedchinese_china.zhs16gbk`可让帮助信息以中文显示，而设置为`American_america`则显示英文帮助。 #### 四、...

    Oracle.pdf

    - **Oracle**：相比之下，Oracle是一款商业软件，通常在大型企业、金融机构如银行、证券公司以及保险公司等领域中使用。由于其高昂的价格，如京东等公司按照CPU核数付费（每一核的永久使用费用约为18万元），Oracle...

    Oracle11.2 命令行手工最简创建数据库的过程

    在`~/.bash_profile`文件中，定义`ORACLE_HOME`指向Oracle 11.2的安装目录，`PATH`包含Oracle的可执行文件路径，`LD_LIBRARY_PATH`指向库文件，`NLS_LANG`设置为区域和字符集，`ORACLE_SID`定义数据库实例名。...

Magicbox
Global site tag (gtag.js) - Google Analytics