Re: Japanese Characters on Win 2000 machine

On 10 Aug 2004 08:54:59 -0500, Galen Boyer <galenboyer_at_hotpop.com> wrote:

> On 9 Aug 2004, ankurgupta26_at_yahoo.com wrote:
>> My application has been developed using VB6 as front end and
>> Oracle 8 as database server. It uses OO40 to access the
>> database.
>>
>> We have set the following NLS_LANG values in the registry for
>> Windows 2000. But it does not support Japanese character set.
>
> W2K does or does not support Japanese character set? My guess is
> you have to get a version of W2K that does.
>
>> They appear correctly when entered however when retrieved from
>> the database they appear as questions marks in the
>> application.
>
> How do you know this? What are you retrieving them with?
> SQLPlus, Toad, ... The point is that those tools need to support
> these UTF8 bytes as well.
>
>> However MS Word correctly displays the Japanese characters
>> after saving on Windows 2000
>
> Well, MSWord could just be saving and displaying a character
> version of these japanese characters, not the true UTF8 bytes.
>
>> The registry setting on Win 2000 is -
>>
>> [HKEY_LOCAL_MACHINE\SOFTWARE\Oracle]
>> "NLS_LANG"="AMERICAN_AMERICA.WE8ISO8859P1"
>>
>> [HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOME0]
>> "NLS_LANG"="AMERICAN_AMERICA.UTF8"
>>
>> However, on Windows XP we have the same NLS_LANG values in the
>> registry and the application supports Japanese as well as
>> english/french and special characters like - Alt + 0130 to Alt
>> + 0160
>>
>> The version of Oracle client on Win Xp and Win 2000 is same -
>> 8.1.6.4.
>>
>> Can you please let us know the registry setting for Windows
>> 2000 machine so that it supports Japanese characters as well
>> english/french and special characters like - Alt + 0130 to Alt
>> + 0160
>
> My guess is that W2K doesn't have support for it built in and you
> need to purchase a version of that OS that does.

I think that guess is wrong, but since all I can say in Japanese is "hello", I doubt I'm an authority on the subject. However, I did come across this:

http://www.ficorp.com/intl_2000.html

...which I think and hope might resolve the issue. If not, it might give the original poster some hints about what keywords to search on at Google for further advice.

Fresh (about 30 minutes ago) from trimphantly getting "Leo Delibes", as stored on my Windows server with an acute e in the usual place, finally displaying correctly on my Linux laptop client, for the first time ever, and after having only spent about two years intermittently trying to sort the problem out, I feel confident that any character set display issues are resolvable... eventually. I hope it won't take our OP two years to do so, however.... but I am not exactly confident on that point!!

Regards
HJR Received on Tue Aug 10 2004 - 10:30:40 CDT