Re: Where do you set NLS_LANG
- From: Surachart Opun <surachart@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Mon, 4 Jan 2010 21:54:23 +0700
1. Fix export NLS_LANG in Script to start Application
Example: http server apache: if you start by "apachectl" file
modify apachectl file by adding
export NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
2. user profile (user use start application)
if you use oracle user (linux)
$ vi ~oracle/.bash_profile
and add
export NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
Or in /etc/profile file
by the way, check NLS_LANG environment before start application
$ env | grep NLS
$ export NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
$ .... start app
Surachart Opun
http://surachartopun.com
On Mon, Jan 4, 2010 at 9:18 PM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:
> I am installing a third-party web application and the vendor is telling
> me to set NLS_LANG on the database server. From what I have read on MOS,
> NLS_LANG is a client side setting and thus should be on the web server.
>
> Can someone confirm my reasoning that this belongs on the web server and
> not the database server?
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
Other related posts:
