Re: Where do you set NLS_LANG

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_at_gcrta.org>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
>

--
http://www.freelists.org/webpage/oracle-l