skian
asked on
Charset linux client->windows server
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no, you don't , just syntax error, check the docs,
I don't remember the correct one either.
I don't remember the correct one either.
ASKER
But, in the third command from the second solution which is the one that
I tried last week, it say :
SQL> alter session set NLS_CHARACTERSET=WE8ISO885
alter session set NLS_CHARACTERSET=WE8ISO885
*
ERROR at line 1:
ORA-00922: missing or invalid option
Do I need to install any optional oracle component ?