Re: Where do you set NLS_LANG

From: Surachart Opun <>
Date: Mon, 4 Jan 2010 21:54:23 +0700
Message-ID: <>

  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


Or in /etc/profile file

by the way, check NLS_LANG environment before start application

$ env | grep NLS
$ .... start app

Surachart Opun

On Mon, Jan 4, 2010 at 9:18 PM, Jeffrey Beckstrom <>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

Received on Mon Jan 04 2010 - 08:54:23 CST

Original text of this message