Re: WO, MySQL and UTF-8 issue
Re: WO, MySQL and UTF-8 issue
- Subject: Re: WO, MySQL and UTF-8 issue
- From: Deirdre Saoirse Moen <email@hidden>
- Date: Thu, 16 Jun 2005 11:14:06 -0700 (PDT)
On Thu, 16 Jun 2005, François Reboursier wrote:
> But when the user types accented letters within a form (for
> instance in a WOTextField) , the letters are saved to the DB as garbage,
> and when I fetch this data from the DB it is read back as garbage. This
> issue persists whether the DB table is configured to use ISO-8859-1or
> UTF-8 character set.
An eacute should look like a checkmark and a copyright symbol when saved
as UTF-8 to your database.
Here's a UTF-8 cheat sheet:
http://www1.tip.nl/~t876506/utf8tbl.html
What collation is your mysql database set to? If it's not the right one,
it may be attempting to translate it, causing problems.
http://dev.mysql.com/doc/mysql/en/charset-database.html
http://dev.mysql.com/doc/mysql/fr/charset-database.html
--
_Deirdre web: http://deirdre.net blog: http://deirdre.org/blog/
"Memes are a hoax! Pass it on!"
_______________________________________________
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