Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:NLS_CHARACTERSET (?)
Try setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
Works here
Dick Goulet
____________________Reply Separator____________________Subject: NLS_CHARACTERSET (?)
Hi Oracle Gurus,
I have problem to display French characters (=E9, =E2
=2E..) on the client side.
I have two DB when I call the first from the client, I
can display these characters:
SQL> select * from kader;
NOM
But when I call the second (from the another machine) on the same machine client and the same OS user I cannot display these characters :
SQL> select * from kader;
NOM
I setted OS user profile like this:
setenv NLS_LANG FRENCH_CANADA
setenv NLS_NUMERIC_CHARACTERS .,
set NLS_SORT binary
setenv NLS_DATE_FORMAT DD-MON-RR setenv NLS_DATE_LANGUAGE AMERICAN setenv NLS_CHARACTERSET WE8ISO8859P1
But in vaine. The DB is oracle 8.0.5 on Solaris but for client and server.
Could you help me.
Kader
=
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- =
Author: Kader Ben
INET: kaderb_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Oct 24 2000 - 14:40:58 CDT