Solved

Charset linux client->windows server

Posted on 2004-04-19
3
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


0
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
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
seazodiac earned 125 total points
ID: 10860785
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;



0
 
LVL 1

Author Comment

by:skian
ID: 10861094
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 ?
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 10861237
no, you don't , just syntax error, check the docs,
I don't remember the correct one either.


0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question