Jump to content

Check out our Community Blogs

Register and join over 40,000 other developers!

Recent Status Updates

View All Updates

- - - - -

Inserting french characters in mySQL DB table


  • Please log in to reply
3 replies to this topic

#1 steph03


    CC Lurker

  • Just Joined
  • Pip
  • 8 posts

Posted 28 August 2009 - 01:12 PM


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!

  • 0

#2 ArekBulski


    CC Devotee

  • Senior Member
  • PipPipPipPipPipPip
  • 480 posts

Posted 06 September 2009 - 02:04 PM

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.
  • 0

#3 LiLMsNinja


    CC Regular

  • Just Joined
  • PipPipPip
  • 42 posts

Posted 10 September 2009 - 05:42 AM

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

#4 phillw


    CC Resident

  • Advanced Member
  • PipPipPipPip
  • 72 posts

Posted 09 October 2009 - 03:59 AM

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.


  • 0

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download