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