Re: Display special characters and accents correctly

On Wed, 29 Sep 1999 19:22:01 GMT, Anil Kamath <akk_16_at_yahoo.com> wrote:

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

The database is created with the correct set as far as I can see. After setting the NLS_LANG to the above value nothing changed. Just to experiment I changed WE8ISO8859P1 to WE8ISO8859P9. This resulted in a question mark instead of the cube. Still no ö.

These are the NLS settings

PARAMETER                 			VALUE
------------------------ 			--------------------
NLS_LANGUAGE              		AMERICAN
NLS_TERRITORY             		AMERICA
NLS_CURRENCY              		$
NLS_ISO_CURRENCY          		AMERICA
NLS_NUMERIC_CHARACTERS    	.,
NLS_CALENDAR              		GREGORIAN
NLS_DATE_FORMAT           		dd-mm-yyyy
NLS_DATE_LANGUAGE         		AMERICAN
NLS_CHARACTERSET          		WE8ISO8859P1
NLS_SORT                  			BINARY
NLS_NCHAR_CHARACTERSET    	WE8ISO8859P1

What I think is strange, is the fact that the character based SqlPlus.exe gives the correct result in a dos-box. So I expect, it is some kind of win95 setting that is conflicting. however spooling gives the same result in both sqlplus and sqlplus80.

regards

Frank

>
>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 Thu Sep 30 1999 - 07:38:17 CDT