Database Software

Hi all,

We have a dedicated server for data bases ( Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 on sun4u sparc SUNW,Sun-Fire-480R) and NLS_LANG= AMERICAN_AMERICA.WE8ISO8859P15 and other servers where we have different applications (one of them is SQL*Plus: Release 10.2.0.4.0 on HP-UX B.11.31 U ia64 ) and in .profile NLS_LANG is set to AMERICAN_AMERICA.WE8ISO8859P1

SQL> select * from NLS_DATABASE_PARAMETERS ;

NLS_LANGUAGE = AMERICAN
NLS_TERRITORY= AMERICA
NLS_CHARACTERSET= WE8ISO8859P15



SQL> SELECT * FROM NLS_SESSION_PARAMETERS ;
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY= AMERICA
NLS_CALENDAR = GREGORIAN

I thought that when using unix system we should set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 so oracle will do the conversion however on the same remote server some scripts export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15).

My question is it correct to export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 on the remote server ?


Thanks
Taha