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: Patrick Robinson <email@hidden>
- Date: Mon, 23 Nov 2009 11:58:13 -0500
Just another couple of ideas:
Regarding (4) below, If your project doesn't use Wonder, then in your
Application constructor, do this:
WOMessage.setDefaultEncoding("UTF8");
Regarding (5), if you're using HTML 4.01 Transitional, then it might
look something like this:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd";>
<html>
<head>
<meta http-equiv="Content-type" content="text/html; charset=UTF-8">
etc.
- Patrick
On Nov 12, 2009, at 8:11 AM, Ramsey Lee Gurley wrote:
Hi Johan,
Just a short checklist that I can think of... Don't forget:
1) The database needs to be storing values in UTF-8. If it isn't,
then all your effort is wasted :) For MySQL that means a db url like
jdbc:mysql://localhost/Example?
capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull&characterE
ncoding=UTF-8
And setting your default charset and collation in your my.cnf file.
2) Different fonts may not have all the characters to display the
different characters. If you're using a default stylesheet, then
the browsers may be displaying differently simply because of
fonts. Speaking of stylesheets, you probably want to encode that
in UTF-8 also. Start your stylesheet with something like
@charset "UTF-8";
@import url("reset.css");
/* Begin site CSS */
3) Set eclipse encoding<Screen shot 2009-11-12 at 7.49.36 AM.png>
4) Use Wonder. Set encoding in the properties file
# Project Encoding
er.extensions.ERXApplication.DefaultEncoding=UTF-8
5) Set encoding in the page wrapper
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN"
"http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg-
flat.dtd">
6) Localizable.strings should be encoded in UTF-16
That's all I can think of off the top of my head. Anyone have
more? Perhaps we should put up a wiki page just for project
encoding since it seems to be something a lot of people stumble on.
Ramsey
On Nov 12, 2009, at 6:07 AM, 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:
⁄€‹›fifl‡°·‚—±Œ„´‰
ˇÁ¨ˆØ∏”’ÅÍÎÏ˝ÓÔÒÚÆ»`¸˛Ç◊ı˜Â¯&
#728;¿
Here in Firefox:
⁄€‹›fifl‡°··‚—±Œ„´‰
ˇÁ¨ˆØ∏”’ÅÍÎÏ˝ÓÔÒÚÆ»¸˛Ç◊ı˜Â¯&#
728;¿
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:
40mac.com
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
_______________________________________________
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