0 Replies Latest reply on Mar 5, 2003 8:28 PM by Eric Chow

    Different locale setting causes data change ?????

    Eric Chow Newbie

      Hello,

      I deployed some Web application in a Win98(with Taiwan Locale, zh_TW),
      when I input some Chinese(BIG5) to the form and save it to database.
      All the Chinese can save to database(MySQL) very well.

      But if I change the Locale to USA(en), all the inputed Chinese characters that save to Database were change code. What caused this?

      If I want my program(web application) that can use in different platform(different country setting) without affect the data storage, how can I do?


      My platforms:

      Case 1)
      OS: Win98 2nd Edition (English version)
      Coutry: Taiwan(zh_TW)
      Language: English
      JDK: JDK1.4.1
      App Server: JBoss(Jetty) 3.0.6
      Database: MySQL 3.23

      ==> Result: Expected and correect Chinese data in database


      Case 2)
      OS: Redhar 8.0
      Country: Macao S.A.R
      Language: English
      JDK: 1.4.1
      App Server: JBoss(Jetty) 3.0.6
      Database: MySQL 3.23

      ==> Result: The Chinese data in database was incorrect, can't recognize, maybe change code.


      Case 3)
      OS: Redhar 8.0
      Country: Macao S.A.R
      Language: Chinese
      JDK: 1.4.1
      App Server: JBoss(Jetty) 3.0.6
      Database: MySQL 3.23

      ==> Result: Expected and correct Chinese data in database

      Best regards,
      Eric