469,643 Members | 2,064 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

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

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

Jul 19 '05 #1
1 6273
bj****@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Wilson | last post: by
8 posts views Thread by pabv | last post: by
1 post views Thread by CYF | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.