Re: Display special characters and accents correctly

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Wed, 29 Sep 1999 19:22:01 GMT
Message-ID: <7stos9$i5j$1@nnrp1.deja.com>

You should be using the Western European Character Set WE8ISO8859P1 for ur database, when u create it. Also ur environment should have this variable NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 set up.

In article <37f23d36.33799025_at_news.xs4all.nl>, no_F.Th.G.Heijmans_at_inter.nl.net_spam (F.Th.G. Heijmans) wrote:
> Hi,
>
> I think that I am really loosing it now. I am trying to spool special
> characters. And I have to say that I really don't understand the
> settings anymore. First of all we are running under windows95.
>
> Let me explain the situation. When I start sqlplus80 and select the
> name of mister Schröder (o" if you have the same problem in this
> screen) it displays with a black cube where the ö should be. When I do
> the same thing in sqlplus (character-based) I get the correct display.
> Spooling gives the same result in both Sql's namely the wrong one. The
> ö gets replaced by ascii character 126.
>
> Mr Schr~der strongly objects to the misuse of his name. Besides, the ö
> is ascii character 148. Which is the character stored in the database.
> Or, that is what ascii() tells me. Since Ascii-char 148 is the correct
> one, I am wondering why it doesn't get displayed and spooled correctly
> in SqlPlus80.
>
> Is there anyone who can explain to me what is happening?
>
> Regards,
>
> Frank Heijmans
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 14:22:01 CDT