Could not store foreign character in MySQL with utf-8
Could not store foreign character in MySQL with utf-8
- Subject: Could not store foreign character in MySQL with utf-8
- From: "Ren, Kevin" <email@hidden>
- Date: Wed, 16 Dec 2009 12:31:52 +1300
- Thread-topic: Could not store foreign character in MySQL with utf-8
Title: 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden