RE: unicode + oracle query....... (suggestions needed...)

From: Kedar Moghe (kmoghe@quark.com.sg)
Date: Wed Sep 27 2000 - 06:12:17 EDT


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