[FM Discuss] Fwd: About http://translate.flossmanuals.net encoding

[adam]

its not the db,...we have no db...its all flat file...its a page
encoding issue. i think its the encoding of the manuals page...i will
look at it


adam


On Mon, 2010-12-13 at 23:01 +1100, Lachlan Musicman wrote:
> On Mon, Dec 13, 2010 at 22:55, adam <adam at xs4all.nl> wrote:
> > if u can look at the webpage and work out what the encoding should be i
> > think i can hack this in
> 
> You should have utf-8 as the default on all fields in all table in
> every database (I presume mysql?). There's no other way to do it.
> 
> It's not fool proof - you will then run into collation problems, but
> that's a well known issue that's being worked on by the wonks.
> Basically collations are "how do we sort UTF8?", and that's where the
> problems start. For two, minor, examples:
> 
> Language	
> Swedish:	z < ö
> German:	ö < z
> 
> Usage
> German Dictionary:	of < öf
> German Telephone:	öf < of
> 
> I've always figured that this is a lesser issue than the actual
> encoding itself. Just make sure the encoding is UTF8 and we can wait
> for the unicode collation algorithm to get more mature:
> http://www.unicode.org/reports/tr10/
> 
> 
> cheers
> L.
> 
> > adam
> >
> >
> > On Mon, 2010-12-13 at 22:50 +1100, Lachlan Musicman wrote:
> >> Was there any fix found for this yet?
> >>
> >> On Fri, Dec 10, 2010 at 10:39, Lachlan Musicman <datakid at gmail.com> wrote:
> >> > On Thu, Dec 9, 2010 at 23:57, James Simmons <nicestep at gmail.com> wrote:
> >> >> Luis has noticed that the left hand menu of the Spanish version of
> >> >> "Make Your Own Sugar Activities!" has some funny characters in it.
> >> >> Does anyone know how to fix that?
> >> >
> >> > It stems from an encoding issue.
> >> >
> >> > For instance, you can fix those chars into  ¿ by changing the encoding
> >> > of the page to Western ISO 8859-1, but then the centre text becomes
> >> > problematic. It looks like the two columns have different encodings at
> >> > some level - probably at the database table or row level in the left
> >> > column (set to Latin, swedish or western). I would suggest that the
> >> > main body of FM is fine, ie already set to UTF-8.
> >> >
> >> > In chromium you can see this by going to options->tools->encoding
> >> > In firefox it's view->character encoding
> >> >
> >> > Depending on how they were encoded in the first place, the best bet is
> >> > to confirm that all tables and rows in the DB are set to UTF-8
> >> > encoding. If not, you can change the encoding and it wont affect the
> >> > content. I can help at a more fine grained level if you want, but it
> >> > can also be done in phpmyadmin (for mysql) or with perl/sed/grep on a
> >> > dump that is re-imported.
> >> >
> >> > If there is still a problem after that, the actual content will need
> >> > to be changed, but only on those chars that are now problematic -
> >> > future chars should be fine.
> >> >
> >> > cheers
> >> > L.
> >> >
> >> >>
> >> >> Thanks,
> >> >>
> >> >> James Simmons
> >> >>
> >> >>
> >> >> ---------- Forwarded message ----------
> >> >> From: Luis Miguel Morillas <morillas at gmail.com>
> >> >> Date: Thu, Dec 9, 2010 at 1:52 AM
> >> >> Subject: About http://translate.flossmanuals.net encoding
> >> >> To: nicestep at gmail.com
> >> >>
> >> >>
> >> >> Hello, Jim
> >> >>
> >> >> I'm preparing an activity for XO. Walter Bender suggested me this link
> >> >> [1]. There is a problem with encoding. I think you're using two
> >> >> different encodigs (the left hand menu and the content). Walter said
> >> >> that you were the responsible of that document ;) .
> >> >>
> >> >> [1] http://translate.flossmanuals.net/ActivitiesGuideSugar_es/Introduction
> >> >>
> >> >> cheers,
> >> >>
> >> >> -- lm
> >> >> _______________________________________________
> >> >> Discuss mailing list
> >> >> Discuss at lists.flossmanuals.net
> >> >> http://lists.flossmanuals.net/listinfo.cgi/discuss-flossmanuals.net
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> > "... imagine a puddle waking up one morning and thinking, 'This is an
> >> > interesting world I find myself in - an interesting hole I find myself
> >> > in - fits me rather neatly, doesn't it? In fact it fits me
> >> > staggeringly well, must have been made to have me in it!' This is such
> >> > a powerful idea that as the sun rises in the sky and the air heats up
> >> > and as, gradually, the puddle gets smaller and smaller, it's still
> >> > frantically hanging on to the notion that everything's going to be
> >> > alright, because this world was meant to have him in it, was built to
> >> > have him in it; so the moment he disappears catches him rather by
> >> > surprise."
> >> > Douglas Adams
> >> >
> >>
> >>
> >>
> >
> >
> > _______________________________________________
> > Discuss mailing list
> > Discuss at lists.flossmanuals.net
> > http://lists.flossmanuals.net/listinfo.cgi/discuss-flossmanuals.net
> >
> 
> 
>