NLS_LANG parameter setting

最新推荐文章于 2021-04-11 15:20:21 发布

忽略的爱

最新推荐文章于 2021-04-11 15:20:21 发布

阅读量640

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： Oracle NLS_LANG

本文链接：https://blog.youkuaiyun.com/huluedeai/article/details/50519653

Oracle 专栏收录该内容

27 篇文章

订阅专栏

文章详细介绍了在Linux环境下通过设置环境变量NLS_LANG和Oracle SQL Developer客户端偏好设置来解决编译过程中出现的问题。重点强调了NLS_LANG参数的作用及其在不同操作系统中的设置方式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

最近改了一个Procedure 里面含有葡萄牙语，结果compile procedure后库中总是显示不对。这是因为我们有一个环境变量NLS_LANG没有设置对的缘故。

solution:

在linux端设置：setenv NLS_LANG PORTUGUESE_PORTUGAL.WE8MSWIN1252

同时在oracle sqldeveloper client端要设置：tools->preference->Database->NLS->PORTUGUESE

After the above steps, compile the procedure then you will find out that the procedure display correctly.

About NLS_LANG Parameters
Oracle provides Globalization Support that enables users to interact with a database in their own language, as defined by the NLS_LANG parameter. When you install Oracle Database Client components, Oracle Universal Installer sets the NLS_LANG parameter in the registry.
The locale setting of your operating system determines the value of the NLS_LANG parameter at installation. Table B-1 lists the operating system locale and NLS_LANG value mappings.
The NLS_LANG parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG subkey, where ID is the unique number identifying the Oracle home.
The NLS_LANG parameter uses the following format:
NLS_LANG = LANGUAGE_TERRITORY.CHARACTER_SET

for the NLS_LANG parameters values you can refer to below link

Commonly Used Values for NLS_LANG