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

From: Frank van Bortel <>
Date: Thu, 24 Feb 2005 09:19:51 +0100
Message-ID: <cvk2j4$6uh$> 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)

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

Original text of this message