Re: UTF-8 forms and database, still some special characters get through as things like fi Why?
Re: UTF-8 forms and database, still some special characters get through as things like fi Why?
- Subject: Re: UTF-8 forms and database, still some special characters get through as things like fi Why?
- From: David Griffith <email@hidden>
- Date: Thu, 12 Nov 2009 13:47:40 +0100
Hi Johan,
Interesting. I still haven't found a solution, been trying all sorts
of things to try and determine exactly what is happening. Everything
else displays fine on the page, but entering the € symbol on the form
converts to strange characters when added to the display group that
displays the items on the page. I ran some output tests to the
console during dispatchRequest() and I can see that the request info
is being received by dispatchRequest() in Latin1 encoding from the
adaptor which shows a certain code (not at that Mac at the moment so I
can't type it exactly) and then when I tell it use use default form
values encoding of UTF-8, it is being converted and the resulting
symbol is represented by \333. This displays as some rubbish
character on the page and also gets saved in the same way in the
database (which seems to indicate that it IS UTF-8 encoded, but it's
not the character it is supposed to be). If I connect to the mySQL
database using NaviCat with UTF-8 encoding and insert a € symbol in
the same field, it displays perfectly on screen when loaded from the
database through the same page on the same application.
I'm stumped.
Regards,
David.
On 12 Nov 2009, at 12:07, Johan Henselmans wrote:
Reading David Griffith's struggle with the euro sign, I thought
checking myself if that worked in my test application.
What I did was: go to a textfield in a form, then (on a mac) press
shift and alt key, and go over the keyboard from 1 in the upper left
to / in the lower right.
Save the stuff, or do something with it, like going to a next form
or back or whatever.
Interestingly, it Seems that some characters are not picked up by
the UTF-8, while others are.
These are the results in Safari:using
⁄€‹›fifl‡°·‚—
±
Œ
„´
‰ˇ
;Á¨ˆØ∏”’ÅÍÎÏ˝ÓÔÒÚÆ»`¸˛Ç◊ı˜Â¯˘¿
Here in Firefox:
⁄€‹›fifl‡°··‚—
±
Œ
„´
‰ˇ
;Á¨ˆØ∏”’ÅÍÎÏ˝ÓÔÒÚÆ»¸˛Ç◊ı˜Â¯˘¿
This is WebObjects 5.4.3, latest wonder, OS X 10.5.8 latest security
updates
Can anyone explain to me why that is?
(I hope the mailserver does not screw up).
Regards,
Johan Henselmans
http://www.netsense.nl
Tel: +31-20-6267538
Fax: +31-20-6279159
_______________________________________________
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
_______________________________________________
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