Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Charset linux client->windows server

Posted on 2004-04-19
3
Medium Priority
?
2,080 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 375 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

688 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