Hi,
My oracle client is a linux box and my oracle server is a windows box.
When I connect with sqlplus from linux to windows, the accentuated
char are printed incorrectly, eg :
1* select 'Et voilà, c''est l''été' from dual
2 ;
'ETVOIL`,C''ESTL''ITI
---------------------
Et voil`, c'est l'iti
When I type this query from a windows box, the result is ok. Here are the param
for my db :
1* select PARAMETER,VALUE from NLS_DATABASE_PARAMETERS
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_RDBMS_VERSION 8.1.7.0.0
Thanks
export NLS_LANG=AMERICAN_AMERICA.
then try to query again in sqlplus
OR in the sqlplus session;
SQL>alter session set NLS_LANGUAGE=AMERICAN;
SQL>alter session set NLS_TERRITORY=AMERICA;
SQL>alter session set NLS_CHARACTERSET =WE8ISO8859P1;
then do the query;