Could not store foreign character in MySQL with utf-8Hi Kevin I have done some tests (has been postponed some time ago) on this subject. Must acknowledge I am just a novice in multilingual web display.
Having said this, my test on the MySquirrel(?) DB on storing and fetching back the UTF-8 chinese characters seemed working fine. All setting are equaivalen to yours, I checked twice. It did stored the value correctly. The next item checkpoint I suggest is could it be the browser or platform related. That's so much I know. Cheers Cheong Hee ----- Original Message ----- From: Ren, Kevin To: [email protected] Sent: Wednesday, December 16, 2009 7:31 AM Subject: Could not store foreign character in MySQL with utf-8 Hi, all, Not sure this is MySQL setup thingy or WO application, In my.cnf file, I have [mysqld] # # * Basic Settings # default-character-set=utf8 default-storage-engine=INNODB Database, table both setup charset=utf8 and char column collation is utf8_general_ci In WO JDBC URL, I have jdbc:mysql://156.13.128.28:3306/school?useUnicode=true&characterEncoding=UTF-8 Any woo file, encoding= "UTF-8"; I can read Chinese character setup in html template and display correctly in web page. But in the textfield, after I type Chinese character and save, I got funny code like 晓文 in database, phpmyadmin and WO web page. Not sure how you guys setup for foreign character in MySQL and WO? thanks Xiaowen(Kevin) Ren Analyst Programmer Channel Applications, Retail Applications ANZ National Bank Ltd Level 6 ASB Tower 2 Hunter Street PO Box 1791 Wellington Phone: 04 4365363 Fax: 04 8028696 "This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication." ------------------------------------------------------------------------------ _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chng34%40gmail.com This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
