topic Re: A question about Oracle on HP-UX in Operating System - HP-UX

A question about Oracle on HP-UX

Wang,MinJie — Thu, 20 Sep 2007 02:17:51 GMT

Hi all
We recently transplanted Oracle database from Windows to HP-UX.
Now we are faced with a serious problem.
Our web application cannot display the characters correctly which it read from Oracle!
I can't understand because there is no difference in "character set" of the database between windows and unix(I have confirmed it when I initialized the database on Unix)

Any advice will be appreciated
Thx in advance

Re: A question about Oracle on HP-UX

meno — Thu, 20 Sep 2007 02:37:29 GMT

Hi,

you have to check how is set NLS_LANG on client which is connecting to the database.
Client NLS_LANG setting is responsible for NLS conversion.

Marian

Re: A question about Oracle on HP-UX

Wang,MinJie — Thu, 20 Sep 2007 02:59:13 GMT

Hey Marian
My client is a windows server
So how can I view and change NLS_LANG

Re: A question about Oracle on HP-UX

meno — Thu, 20 Sep 2007 03:19:40 GMT

Hi,

you can view and set in more ways.
- first is setting session variable NLS_LANG e.g. AMERICAN_AMERICA.UTF8
- second is system environment variable NLS_LANG
- third is registry key HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> OraClientHome(or something like this) -> NLS_LANG

Marian

Re: A question about Oracle on HP-UX

Wang,MinJie — Thu, 20 Sep 2007 03:30:08 GMT

Hey Marian
I want to know the exact name of charset on Oracle server.
How can I know it
Is the following command correct?:
SQL>select userenv(â languageâ ) from dual;

Re: A question about Oracle on HP-UX

Wang,MinJie — Thu, 20 Sep 2007 03:30:34 GMT

Hey Marian
I got it Thx
Now I want to know the exact name of charset on Oracle server.
How can I know it
Is the following command correct?:
SQL>select userenv(â languageâ ) from dual;

Re: A question about Oracle on HP-UX

meno — Thu, 20 Sep 2007 03:47:38 GMT

Hi,

you can see all abou your NLS in this 3 views:
----------------
- NLS_SESSION_PARAMETERS shows the NLS parameters and their values for the session that is querying the view. It does not show information about the character set.

- NLS_INSTANCE_PARAMETERS shows the current NLS instance parameters that have been explicitly set and the values of the NLS instance parameters.

- NLS_DATABASE_PARAMETERS shows the values of the NLS parameters that were used when the database was created
------------------------

Maybe this manual pages could help you
for 9i (see Chapter 3):
http://download.oracle.com/docs/cd/B10501_01/server.920/a96529/toc.htm

for 10g:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/toc.htm