i mean all the entries ....at both Web server machine's registry and Oracle
Database server machine's registry or either one.....
in our setup... my machine is the Web Server and the Oracle Server is a
separate machine....
please clarify....
regards,
Sandeep
----- Original Message -----
From: Kedar Moghe <kmoghe@quark.com.sg>
To: Unicode List <unicode@unicode.org>
Cc: <unicode@unicode.org>
Sent: Wednesday, September 27, 2000 3:21 PM
Subject: RE: unicode + oracle query....... (suggestions needed...)
Sandeep,
I think you need to change at following three places,
HKEY_LOCAL_MACHINE\ORACLE\NLS_LANG
HKEY_LOCAL_MACHINE\ORACLE\ALL_HOMES\ID0\NLS_LANG
HKEY_LOCAL_MACHINE\ORACLE\HOME0\NLS_LANG
Best of luck
Regards,
Kedar
-----Original Message-----
From: Sandeep Krishna [mailto:sandeepkrishna@noida.hcltech.com]
Sent: Wednesday, September 27, 2000 5:45 PM
To: Carl W. Brown; Bob Verbrugge; Kedar Moghe
Cc: unicode@unicode.org
Subject: Re: unicode + oracle query....... (suggestions needed...)
hi...
i m thoroughly confused.....
actually the registry entries for oracle shows 3 entries for NLS_LANG.
and that too at the WEB SERVER end and at the DATABASE SERVER end.....
so that makes tooooooo many combinations...
can someone indicate which of these NLS_LANG entries have to be set as
"AMERICAN_AMERICA.UTF8" and if some of them doesnt need this...what exactly
should be there....
pls suggest necessary messures......
regards,
Sandeep
----- Original Message -----
From: Bob Verbrugge <bverbrug@redwood.nl>
To: Sandeep Krishna <sandeepkrishna@noida.hcltech.com>
Sent: Wednesday, September 27, 2000 1:30 PM
Subject: Re: unicode + oracle query....... (suggestions needed...)
Sandeep,
You probably need to change the NLS_LANG Oracle setting in the registry.
Look under
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE for this setting and change the
character set part to UTF8.
Bob.
----- Original Message -----
From: "Sandeep Krishna" <sandeepkrishna@noida.hcltech.com>
To: "Unicode List" <unicode@unicode.org>
Cc: <unicode@unicode.org>
Sent: Wednesday, September 27, 2000 9:16 AM
Subject: Re: unicode + oracle query....... (suggestions needed...)
> hi,
>
> thankx for responding.....
>
> but when u mention change in the registry..
> could u elaborate about where exactly in reg and what changes are required
>
> my registry setting shows NLS = American_English.UTF8.
>
> is this the setting u indicated..or something to so with the charset entry
:
> autodetect and autodetect_all (in classid...Mime>database>charset..)
>
> pls do elaborate....
>
> regards,
>
> Sandeep
>
>
>
> ----- Original Message -----
> From: Kedar Moghe <kmoghe@quark.com.sg>
> To: 'Sandeep Krishna' <sandeepkrishna@noida.hcltech.com>
> Sent: Wednesday, September 27, 2000 11:20 AM
> Subject: RE: unicode + oracle query....... (suggestions needed...)
>
>
> Sandeep,
>
> I think you need to set the registry charset to UTF8 where database is
> installed. We were was getting the same problem when we use to send UTF-8
> strings to oracle database after conversion from Shift-JIS to UTF8. That
> time also the byte sequence of the retrieved string is getting changed and
> some of the bytes are getting replaced with BF.
>
> Regards,
>
> Kedar
>
> -----Original Message-----
> From: Sandeep Krishna [mailto:sandeepkrishna@noida.hcltech.com]
> Sent: Wednesday, September 27, 2000 11:36 AM
> To: Unicode List
> Subject: unicode + oracle query....... (suggestions needed...)
>
>
> hi....
>
> actually i have been trying to use ASPs (UTF-8 encoding..) to write
unicode
> cahracters to an Oracle DB table (varchar2 field)... and then retrieve
them
> back..
> (i used UTF-8 encoding for both writing to the database and also for
> retriving and displaying..)
>
> there were some amazing observations...
>
> * each unicode character was taking 7 bytes in the database. (instead of
> expected 2 or 3...)
> * some unicode characters(or rather code points.) like' F95F' when encoded
> in UTF-8 was being encoded as EF A5 BF, when it should have been encoded
as
> EF A5 9F.. in fact many unicode charcters whose encoded form had to had a
> byte in the range (80..9F) were being somehow changed to BF ... thus
> resulting in incorrect retrieval....
>
> I was unable to find the reasons for these strange occurrences....
> Pls suggest what could be the causes for these......
>
> regards,
>
> Sandeep.
>
>
>
>
****************************************************************************
> *******************
> SANDEEP KRISHNA
> Member Technical Staff (Priceline.com)
> H.C.L. Technologies Limited
> A-1 C&D, Sector -16, NOIDA, UP, India.
> Ph: 91-11-91-4516321 (extn. 1062)
> Fax: 91-11-91-4510713, 4510226
> E-Mail : sandeepkrishna@noida.hclt.com
> <mailto:sandeepkrishna@noida.hclt.com>
>
>
>
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:14 EDT