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 <[EMAIL PROTECTED]>
To: 'Sandeep Krishna' <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
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 : [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>



Reply via email to