Hi,
did search in WO list and google found this,
http://wiki.objectstyle.org/confluence/display/WO/Web+Applications-Development-Localization+and+Internationalization
so far so good, everything is fine in database, phpmyadmin and browser. all get
Chinese character.
thanks
Kevin
_____
From: Cheong Hee (Gmail) [mailto:[email protected]]
Sent: Wednesday, 16 December 2009 6:24 p.m.
To: Ren, Kevin; [email protected]
Subject: Re: Could not store foreign character in MySQL with utf-8
Hi 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 <mailto:[email protected]>
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]
"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/archive%40mail-archive.com
This email sent to [email protected]
