Re: NLS_LANG for HP Service Desk.

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<q9s500tp37q8s49m9t8ssf1r79un3jehib_at_4ax.com>...
> On 12 Jan 2004 10:18:22 -0800, lem_i_at_mail.ru (Igor Lemeshko) wrote:
>
> >Hi ALL,
> >
> >I need to change NLS_LANG for HP Service Desk.
> >I have to have the same value of NLS_LANG at both sides - in database
> >and in Oracle client software.
> >It's necessary for properly display of non-english text.
> >Service Desk doesn't use the value of current Oracle client NLS_LANG and
> >I'm not able to find where Service Desk saves value for NLS_LANG.
> >May be Service Desk uses some configuration files, may be registry.
> >
> >Any help would be very appreciated,
> >Igor Lemeshko.
>
>
> NLS_LANG is a client only variable, you can't use it in the database.
> To set it just make sure you have the env var NLS_LANG set
> appropiately in your .profile or even in oraenv and/or set NLS_LANG as
> a registry variable in HKLM\software\oracle in Winblows

I have database with NLS_CHARACTERSET = WE8ISO8859P15. In case of the Oracle client has the same NLS_LANG(for example AMERICAN_AMERICA.WE8ISO8859P15) there will be no problems with displaying
non-english chars(may be there will be problem with sorting, but not with displaying of chars).
I can enter in database and query (sqlplus) non-english chars with such configuration, but I'm not able to do the same using HP Service Desk(instead of russian
language, I see something like ????).
So, HP Service Desk doesn't use Oracle environment to find NLS_LANG, and it's the question.
I just now know HP Service Desk works with Service Desk application server
which uses JDBC for connection to database and I have to find solution here(adjustment of the JDBC).

BGW,
Igor Lemshko. Received on Tue Jan 13 2004 - 08:59:20 CST