how to change nls parameters ?

black_snail 2002-08-01 07:55:01

for displaying the Chinese character in oracle ,
how to change nls parameters ?

...全文

39 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

porpoise11 2002-08-02

打赏
举报

改注册表的nls_lang为SIMPLIFIED CHINESE_AMERICA.ZHS16GBK 中文字符
为AMERICAN_CHINA.ZHS16GBK 英文字符

kmlinda 2002-08-02

打赏
举报

there're 2 types of nls parameter :
1st is client nls parameter
if only want to do some queries in client and use Chinese character,chanage the config of client nls parameters:
regedit--->\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\nls_lang
change to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

2nd is server nls parameter
it's more difficute then 1nd.show oracle document NLS department.

The globalization support in Oracle Database enables you to store, process, and retrieve data in native languages.It ensures that database utilities, error messages, sort order, and date, time, ...

个人总结环境 OSrhel5.4 x86 64DBCOL PRODUCT FORMAT A55 COL VERSION FORMAT A15 COL STATUS FORMAT A15 SE...

In this DocumentApplies to:OracleDatabase - Standard Edition - Version 8.1.7.4 andlaterOracle Database - Enterprise Edition - Version 8.1.7.4 andlaterInformation in this document applies to anyplatfor...

How To Recreate A Database Using TTS (Transportable TableSpace) [ID 733824.1]In this DocumentGoalFixRefer...

NLS_LANG Client Settings and JDBC Drivers (文档 ID 115001.1) PURPOSE The purpose of this article is to summarize ways to access an Oracle database from a client when a Java-based application is used...