Re: UTF8 note decoded when reading from the database

<johnny9_at_gmail.com> wrote in message
news:1171584496.897161.70370_at_a34g2000cwb.googlegroups.com...
>I have a VB6 / ADO application that can successfully write japanese
> characters to a UTF8 10g database, but when I read from a CHAR/
> VARCHAR2 field the string looks as though it is the ninary
> representation of utf8... ie, it looks like it did not get converted
> from UTF8.
>
> I have NLS_LANG set to AMERICA.UTF8.
>
> My Oracle Client Drivers are 9.2.
>
> My Oracle Database is 10g.
>
> I can confirm that the data has been written correctly to the database
> by using another tool to read the fields. I will also be using other
> languages in the database.
>
> Any ideas on what I can do so that Oracle converts the fields
> correctly?
>

Well, if you are setting your NLS_LANG to UTF8 and you know that UTF8 is stored in the database then oracle is not doing anything to convert the data since the client and db use the same character set. (note it is a rare thing to do typically you have some other charset defined on the windows side, but technically it is possible) Whatever gui you use will be responsible for displaying the utf8 data perhaps your gui component is not utf8 aware.

There are two windows apps I know of to display UTF8 data. isqlplus ( this is the web version ) or sql developer ( when you set the charset to utf8).

If you have access to metalink check out note 179133.1

HTH
Scott. Received on Thu Feb 15 2007 - 18:40:31 CST