Inserting french characters in mySQL DB table

[steph03]

Hello,

I am having a major issue with inserting french characters in my mySQL DB. The french charaters display perfectly fine on the client-side page. If I edit a field directly in the phpMySQL control panel, the french characters also displays correctly.
But if I insert or update fields from a form on a webpage (using PHP), it converst the special french characters into something not readable. For example, à becomes à Â.

I feel as if I've tried it all... any ideas?? here are the variables set on my server for phpMySQL:
*********************************************
character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_general_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci
********************************************

Any ideas or suggestions would be much appreciated!

Thanks,
Steph

[ArekBulski]

I remember when I installed MySql there was a question which charset it should use, and I chose UTF8 for eveyrthing. I see some things are latin1 or else, I don't know can these support french characters. Maybe not?

I think those settings can be changed to UTF8 using the administration tool.

[LiLMsNinja]

I'm not sure about mySQL but you are going to want the equivelant to nvarchar datatype.

[phillw]

There is a brief, but informative thread on the MySQL site on just this occurance ...

MySQL :: Problem inserting german and french characters

Hope that helps.

Regards,

Phill.