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

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 values of NLS_LANG on all the clients (mind you: your iAS server is a client to the database!) My guess is, somewhere there is a WE8ISO8859P1... which is a single byte characterset - thus losing the better half of your traditional chinese characters.

As Java and MS Windows use 16 bit UTF code, you're best off with the AL16UTF16 characterset; no conversions are needed that way.

-- 
Merry XMAS and a happy 2005,
Frank van Bortel