Jump to content




Recent Topics

Recent Status Updates

  • Photo
      18 Aug
    KodeKool

    When faced with a wall of errors and no hope to fix them, remember the following "Programs always do what you tell them to, and seldom what you want them to, but eventually you'll run out of things that can go wrong and it'll just work. and that's the secret to good programming."

    Show comments (2)
View All Updates

Developed by Kemal Taskin
Photo
- - - - -

Inserting french characters in mySQL DB table

mysql

  • Please log in to reply
3 replies to this topic

#1 steph03

steph03

    CC Lurker

  • Just Joined
  • Pip
  • 8 posts

Posted 28 August 2009 - 01:12 PM

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

#2 ArekBulski

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

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

phillw

    CC Resident

  • Member
  • PipPipPipPip
  • 70 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.

Regards,

Phill.
  • 0





Also tagged with one or more of these keywords: mysql