Re: Odd comments bug?

[Thomas Wood <thos gnome org>]

Luke Stroven wrote:

> On Mon, 2005-06-20 at 21:38 +0100, Thomas Wood wrote:
>  
>
> > I've noticed there are a couple of comments that are coming up as lots
> > of html entities (see: http://art.gnome.org/themes/icon/1001 and
> > http://art.gnome.org/backgrounds/other/1074). Does anyone have any ideas
> > what could be causing these?
> >    
>
>
> Looks like you have something like htmlspecialchars converting the
> ampersands to html entities.
>
> For instance that one comment reads 
>
> "Чета чересчур зеленая, ну а так сойдет под определенные темы, (надо
> только найти такую тему:))"
>
> When you convert the &amps back to ampersands.
>
> Have no idea what that comment says though.
>
>  
Ok, so I'm guessing the web browser is sending the value from the 
<textarea> as html entities. This causes a problem since as you say, we 
are passing all database text through htmlspecialchars. The other 
problem is that the mysql database uses the latin-1 charecter set, which 
possibly means we couldn't store these characters in it, and I would 
rather not store html in the database since it makes it more difficult 
to be used in non-html aware applications.

We could delete entries like this in non-english languages, although I 
would prefer not too if possible, but it does make moderation difficult.

Does anyone have any ideas for a solution?

-Thomas