Re: NLS_CHARACTERSET (?)

Many thanks Mike,

Kader

• mike ding <mding1997_at_mail.net> wrote:
  > Try to set nls_lang to french_canada.us7ascii.
  > Please don't use weiiso. Also
  > your nls_lang is not correctly set, and just delete
  > the entry for
  > nls_character. It should be ok.
  >
  > mike
  >
  > ----- Original Message -----
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > Sent: Tuesday, October 24, 2000 10: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: mike ding
  > INET: mding1997_at_mail.net
  >
  > 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).
  

  ---