Re: Oracle, NT and norwegian characters

RG <ronny.jobb_at_c2i.net> wrote in message news:<3B42C7D5.14E454A0_at_c2i.net>...
> Hi!
>
> Can anyone help me on this one?
> My problem is that when I put norwegian characters (like æ,ø and å) in
> the Oracle db through my web-site (with ASP), all those special
> characters are converted to ?'s.
> Why is this happening?
> When I insert these characters via SQL*PLUS on Solaris the norwegian
> letters stays norwegian :), but when displayed on the web, they now
> suddenly changed to f's or some other character. I think this is not a
> Oracle problem, but more an NT, ODBC or maybe a PersonalWebServer
> problem.
>
> My config:
> Oracle 8.1.5 running on a Solaris system (Solaris 8).
> The ODBC driver is "Microsoft ODBC for Oracle ver. 2.573.6526.00"
> My "web-server" is the MS Personal Web Server running on WinNT WS 4.0
> with SP6.

Generally, when characters are incorrectly translated to '?', the problem is the result of the client and server machines having different character sets. First, you'll want to find out what the NLS (National Language Settings) are on your database. Hopefully, the database has been set up to be Unicode, but any character set that contains the special Norwegian characters should be sufficient. Next, find out what your NLS settings are on the client machine. Since you're using the Microsoft ODBC for Oracle driver, you'll also have to make sure that the Windows regional options are set up properly.

Justin Cave Received on Thu Jul 05 2001 - 22:27:17 CEST