rawb Posted February 25, 2009 Share Posted February 25, 2009 Ok I've got kind of a weird character encoding problem that I'm going to try to describe as best I can . Basically, I'm having a lot of trouble rendering French characters and there seems to be a general consensus (on google) that utf-8 is the way to go for French. The MySQL database is set up to use the 'utf8_general_ci' collation, and my HTML also uses utf-8 character encoding like so: <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> The Problem: When using the utf-8 character encoding on my html pages, everything appears to work perfectly. However, when I go to PHPMyAdmin and check the database, it inserts weird characters ('é' instead of 'é', for example). When using the 'ISO-8859-1' charset on my HTML pages, everything inserts and retrieves correctly (this is what I'm currently doing). The thing is, I would really like to use the utf-8 charset in my HTML to keep things consistent between my database and my HTML. If this charset is supposed to be able to support French, then why is it doing this? Thanks in advance! Link to comment https://forums.phpfreaks.com/topic/146794-weird-character-encoding-behavior/ Share on other sites More sharing options...
lyxus Posted February 25, 2009 Share Posted February 25, 2009 I have exactly the same problem any way how i can clean my database. I can use a windows or Unix client does not matter. And which encoding should use ! Thanks Link to comment https://forums.phpfreaks.com/topic/146794-weird-character-encoding-behavior/#findComment-770703 Share on other sites More sharing options...
fenway Posted February 25, 2009 Share Posted February 25, 2009 So there's nothing wrong with the db... make sure PHPMyAdmin is correctly configured, I suppose. Link to comment https://forums.phpfreaks.com/topic/146794-weird-character-encoding-behavior/#findComment-770827 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.