BIG5 Encoding - mich...@kmb.hk - com.mysql.lists.java

3 messages in com.mysql.lists.javaBIG5 Encoding

From	Sent On	Attachments
mich...@kmb.hk	05 Aug 2004 18:08
Mark Matthews	05 Aug 2004 18:23
mich...@kmb.hk	05 Aug 2004 18:44

Subject:	BIG5 Encoding
From:	mich...@kmb.hk (mich...@kmb.hk)
Date:	08/05/2004 06:08:46 PM
List:	com.mysql.lists.java

Hi,

I want to store some chinese characters (using BIG5-HKSCS encoding) to MySQL database (Version 4.0.20) thru Connector J (3.0)

Character set of MySQL is latin1 and i added "characterEncoding=BIG5_HKSCS" to the connection string.

Everying fine and i can store and retrieve data with chinese characters.

However, when i enter following chinese characters "�功�" (in hex : b3 5c a5 5c bb 5c), the characters stored in MySQL is incorrect since hex 5c is "\" and removed from the characters string.

I assume the data path is Web Browser (UTF-8 encoding) -> Tomcat (UTF-8) -> Java (UTF-8) -> Connector J (Big5) -> MySQL

Regards, Michael

??????????????????????????????????????????????????????????????????????????????????????????????????????????? ??????????????????????

???????????????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????? ??????????????????????????

???????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????? ????????????????????????????????