Posted by Juliette on 02/24/07 07:22

gehegeradeaus@gmail.com wrote:
> Hi,
>
> I'm running php5 and mysql5, both configured for utf8... When I save
> data into a table, and look at the table with e.g. phpmyadmin, the
> data
> has weird characters like: è and é in it.Actually this isn't a
> big problem: when I print the data in my browser, the accents look
> fine.
>
> I read that when you execute a query "SET NAMES utf8", the weird chars
> would disappear in the db, ...and still everything works fine.
>
> So I tried to decode the utf8 data in my tables with using
> utf8_decode... But it seems like it doesn't decode everything.
>
> For example this doesn't work :echo utf8_decode('Problème à la
> sauvegarde des données.');
>
> You will notice the à isn't converted into an à.
>
> So I have 2 questions :
>
> - should i use the SET NAMES query, or is it normal when you have
> those
> characters in your table
> - how can I convert the à into an à
>
> Thanks in advance!
>

You might want to have a look here for some more information:
http://adviesenzo.nl/examples/php_mysql_charset_fix/

[Back to original message]