• 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
Could not store foreign character in MySQL with utf-8
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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 &#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 Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Could not store foreign character in MySQL with utf-8
      • From: "Cheong Hee (Gmail)" <email@hidden>
  • Prev by Date: Re: Building for deployment
  • Next by Date: Re: Oracle and EOF with Timestamps
  • Previous by thread: Re: _eofInv_ thingy!
  • Next by thread: Re: Could not store foreign character in MySQL with utf-8
  • Index(es):
    • Date
    • Thread