Re: Oracle, NT and norwegian characters

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

Thank you for your response! I think now I'm a litte closer to a solution :)

I've been reading the documentation concerning NLS, and you're right. It looks like my problem is different language settings between client and server. When I see the info in NLS_INSTANCE_PARAMETERS the language is American, the territory is America (but unfortunately I don't see the character set there). Now I want to change this to language American, territory Norway and character set WE8ISO8859P1.
I've read that you can set this in init.ora (or in init****.ora for a specified database). What I didn't find out was _how_ to set this properly in init.ora. I suppose it is the line: NLS_LANG=AMERICAN_NORWAY.WE8ISO8859P1 that should change the language in my Oracle database. (I want my error messages in American, but the database must understand the Norwegian characters I put there). Am I right at this one, or am I only doing this worse for myself?

Ronny G Received on Tue Jul 10 2001 - 08:30:06 CEST