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

Solved

Charset linux client->windows server

Posted on 2004-04-19

Oracle Database

1 solution

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

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 375 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 Unravel a Tricky Query

Article by: sdstuber

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. …

Oracle Database

Some Useful Settings in JasperReports Server

Article by: Doug

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.

Basic RMAN Backup Configuration

Video by: Steve

Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

Oracle Database

Dealing with Dates in Oracle Database

Video by: Steve

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.