Re: How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 24 Feb 2005 09:19:51 +0100
Message-ID: <cvk2j4$6uh$1_at_news3.zwoll1.ov.home.nl>


bjwang_at_acs.com.tw wrote:
> Hello wisers,
>
> We are testing a system which is developed on top of Oracle 9iAS. The
> client PCs are using Internet Explorer to access the system. We are
> sure that the Oracle 9i database server is set to use Unicode. The
> Oracle 9i database server and Oracle 9iAS server are now running on
> English Windows 2000 server. With client PCs running on traditional
> Chinese Windows 2000 or traditional Chinese Windows XP, via Internet
> Explorer we put traditional Chinese text into the system then query the
> data again, it displays in inverted question marks.
>
> 1. How to resolve the problem?
> 2. Does the Internet Explorer View -> Code Unicode (UTF-8) setting
> controls content display as well as keyin?
> 3. Or the system controls the code interpretation of keyin?
> Thanks,
>
> Bruce
>
Check the "client" settings; on the iAS machine, there probably is an NLS_LANG entry for an 8bit, fixed character set, like WE8ISO8859P1. This would be the default for English operating systems.
You want the AL16UTF16 (closest to what MS Windows produces)

-- 
Regards,
Frank van Bortel
Received on Thu Feb 24 2005 - 09:19:51 CET

Original text of this message