dbTalk Databases Forums  

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

comp.databases.oracle comp.databases.oracle


Discuss How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bjwang@acs.com.tw
 
Posts: n/a

Default How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer - 02-23-2005 , 05:05 PM






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


Reply With Quote
  #2  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: How to put traditional Chinese text into Unicode Oracle 9i databasevia Internet Explorer - 02-24-2005 , 02:19 AM






bjwang (AT) acs (DOT) com.tw wrote:
Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.