Re:NLS_CHARACTERSET (?)

Thanks Dick for reply.

Kader

• dgoulet_at_vicr.com wrote:
  >
  > Try setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
  >
  > Works here
  >
  > Dick Goulet
  > ____________________Reply
  > Separator____________________
  > Author: Kader Ben <kaderb_at_yahoo.com>
  > Date: 10/24/00 6:40 AM
  >
  > Hi Oracle Gurus,
  >
  > I have problem to display French characters (é, â
  > ...) 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âli
  > Tétéavertisseur
  >
  > 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
  > also send the HELP command for other information
  > (like subscribing).
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author:
  > INET: dgoulet_at_vicr.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
  > also send the HELP command for other information
  > (like subscribing).
  

  ---