Link to home
Start Free TrialLog in
Avatar of skian
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


ASKER CERTIFIED SOLUTION
Avatar of seazodiac
seazodiac
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of skian
skian

ASKER

Ok the first solution works, thanks -- I'll give you the points.

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=WE8ISO8859P1;
alter session set NLS_CHARACTERSET=WE8ISO8859P1
*
ERROR at line 1:
ORA-00922: missing or invalid option

Do I need to install any optional oracle component ?
no, you don't , just syntax error, check the docs,
I don't remember the correct one either.