Solved

Charset linux client->windows server

Posted on 2004-04-19

Oracle Database

1 solution

2,078 Views

Last Modified: 2007-12-19

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

Comment

Question by:skian

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 23

Accepted Solution

by:seazodiac

seazodiac earned 125 total points

ID: 108607852004-04-19

in your LINUX client machine, open a bash shell

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

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;

LVL 1

Author Comment

by:skian

ID: 108610942004-04-19

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 ?

LVL 23

Expert Comment

by:seazodiac

ID: 108612372004-04-19

no, you don't , just syntax error, check the docs,
I don't remember the correct one either.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle

Article by: sdstuber

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…