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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bjwang@acs.com.tw
    #1

    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

    Tags: None
    • Frank van Bortel
      #2
      Re: How to put traditional Chinese text into Unicode Oracle 9i databasevia Internet Explorer

      bjwang@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

        Comment

        Previous template Next
        Working...