FWIW, I also use Unicode=true in the connection URL:
jdbc:mysql://localhost/Example? capitalizeTypenames=true&useUnicode=true&characterEncoding=UTF-8

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&characterEncoding=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:

&#8260;€‹›&#64257;&#64258;‡°·‚— ± Œ „´ ‰&#711 ¨ˆØ&#8719;”’ÅÍÎÏ&#733;ÓÔ&#63743;ÒÚÆ»`¸&#731;Ç&#9674;&#305;˜Â¯&#728;¿

Here in Firefox:

&#8260;€‹›&#64257;&#64258;‡°··‚— ± Œ „´ ‰&#711 ;Á¨ˆØ&#8719;”’ÅÍÎÏ&#733;ÓÔ&#63743;ÒÚÆ»¸&#731;Ç&#9674;&#305;˜Â¯&#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      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/rgurley%40mac.com

This email sent to rgur...@mac.com

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com

This email sent to kieran_li...@mac.com

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to