Re: NLS - Displaying special Swedish characters
Date: Fri, 24 Nov 2000 20:09:27 GMT
Message-ID: <3A2805A0.78533B7E_at_home.nl>
IIRC, all "non-standard" (read: all non-US) characters have to be encoded.
I would think you have a routine, that translates æ, Å, å, etc to the
corresponding HTML escaped characters.
That would be a programmatic thing - you write your own routine,
or use a supplied routine, in e.g. PL/SQL.
Display settings and database settings are something different, and
will not influence webbrowsers in displaying the above (escaped HTML)
characters.
I would suggest setting trace_level_client=16 in sqlnet.ora on the client
side, and fire up a simple login.
You will see the characters sets being exchanged, as well as alter session
set nls_lang commends (if appropiate). Maybe that will give a clue in the
direction to look for - I assume you now know 400% sure your database
stores in the correct charset, and was created as such, etc, etc.
Steve wrote:
> I have been in contact with Oracle about this for nearly 1 month, and they
> are now clutching at straws. So far, we have discovered that the database
> is storing the characters correctly as I have sent oracle the block to
> check. They now think it is something to do with the way it is being
> displayed on the screen, stty settings.
>
> But would this effect the result on the web site??
>
> I am using America_American.UTF8
>
> 8.1.6 on Sun 5.6
>
> Any comments greatly appreciated.
>
> regards,
>
> Steve.
-- Hth, Frank van BortelReceived on Fri Nov 24 2000 - 21:09:27 CET