MySQL Forums
Forum List  »  Knowledge Base

Inserting french characters in mySQL DB table
Posted by: Stephane Halle
Date: August 31, 2009 09:31AM


I feel like this has been discussed a whole bunch on different forums but still, I haven't been able to find out what's wrong with my set up...
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!


Options: ReplyQuote

Written By
Inserting french characters in mySQL DB table
August 31, 2009 09:31AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.