Re: Display special characters and accents correctly

The NLS_LANG variable needs to be an environment varibale in your system settings (for NT)..or wherever the ORACLE_SID is getting set. For Unix,,you can set it in your .cshrc file.

In article <37f3583c.1789326_at_news.xs4all.nl>,   no_F.Th.G.Heijmans_at_inter.nl.net_spam (F.Th.G. Heijmans) wrote:
> 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.
>
>

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 09:45:31 CDT