• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
RE: Could not store foreign character in MySQL with utf-8
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Could not store foreign character in MySQL with utf-8

  • Subject: RE: Could not store foreign character in MySQL with utf-8
  • From: "Ren, Kevin" <email@hidden>
  • Date: Thu, 17 Dec 2009 15:51:33 +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,
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@hidden]
Sent: Wednesday, 16 December 2009 6:24 p.m.
To: Ren, Kevin; email@hidden
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
To: email@hidden
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 &#26195;&#25991; 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 email sent to email@hidden

 

 

"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
  • Prev by Date: Re: Email WOes
  • Next by Date: Clob in Derby database
  • Previous by thread: Re: Could not store foreign character in MySQL with utf-8
  • Next by thread: JFreeChart/Wonder liftoff
  • Index(es):
    • Date
    • Thread