Posted by gehegeradeaus on 02/22/07 22:02

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!

• Next in forum: Re: Are there any good solutions for checking the validity of IP address?
• Prev in forum: Are there any good solutions for checking the validity of IP address?
• Thread view: utf8

[Reply to this message]