Setting problem? "é" becomes "é" in mysql.

[jjshell]

hi,
i really have a strange problem. i have a form. when the form is submitted, the data is inserted in the db. the strange thing is that, in mysql, letters like é, à, è are translated into stuff like that: é à è.

I don't do anything that could change the letters before inserting them in the db.

does anyone have the slightest idea of what's happening?

[jjshell]

Here is the exact change:

é à è ü ö ä ' É

becomes (in the same order)

é à è ü ö ä ' �

I am viewing the field using phpmyadmin. The letters are displayed exactly like that.

The strangest thing that I just noticed is that if I display the field in a <textarea>, all theletters are displayed as expected.

I am kinda lost, as you can guess...

Don't feel that you have to provide an exact answer to this. Don't hesitate to give advice etc...

thanks

[Icheb]

Afaik it has to do with the charset that is being used. It doesn't really matter how it's being displayed in phpMyAdmin as long as it's ok for the webinterface of your site, right?

[jjshell]

Actually it's displayed in avery funky way everywhere. But I have finally identified the problem.

It was tough though...

The problem has to do with the doctype... If one is added, the chars get all funky...

I will try to ask my question in the proper forum. Sorry to have bothered you guys.