Re:NLS_CHARACTERSET (?)

From: <dgoulet_at_vicr.com>
Date: Tue, 24 Oct 2000 15:40:58 -0400
Message-Id: <10659.120091@fatcity.com>

Try setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1

Works here

Dick Goulet

____________________Reply Separator____________________

Subject: NLS_CHARACTERSET (?)
Author: Kader Ben <kaderb_at_yahoo.com>
Date: 10/24/00 6:40 AM

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

B=E2li
T=E9t=E9avertisseur

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

Bbli
Titiavertisseur

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

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
-- =

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