Re: Skripts with Unux and german special characters

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 26 Aug 2004 17:55:49 +0200
Message-ID: <412e0849$0$26987$626a14ce@news.free.fr>

"Nicolas Bronke" <Nicolas_bronke_at_web.de> a écrit dans le message de news:2p69dnFhgdluU1_at_uni-berlin.de...
> With some of my collegues we entcountered a problem with german characters
> under Linux.
>
> Normally we are loading our scripts from a windows client. There we did not
> have any problems. But now someone want to load the scripts from linux using
> sqlplus. Here we are comming to the problem. Even if I send
>
> select convert('äöü','WE8ISO8859P1') from dual;
>
> we did not get the german characters. I search in Google and discussed it
> with others. Sure it have to be a setting problem, but I did not find the
> way how to set the parameters (even not the person, who has much more
> experiences with Linux).
>
> Can some give us a helpful hint?
>
> Regards
> Nicolas
>

To be able to see German characters you have to satisfy several conditions:

1- use a NLS_LANG with character set containing these characters
2- use a program that can display these characters
3- use an OS than can handle these characters
4- use a terminal (and eventually emulator) that can display these characters
5- if you are in client/server or n-tiers environment, these conditions must be satisfied at all

steps

Are all these conditions satisfied?

-- 
Regards
Michel Cadot

Received on Thu Aug 26 2004 - 10:55:49 CDT