Page 1 of 1

Problem with some symbols(words) in Mozilla

Posted: Tue Oct 13, 2009 2:53 pm
by MicroBoy
I made a mistake and converted my php files to a format that I don't remember, Now it doesn't matter to what format I convert, I used "UTF-8 without BOM","UTF-8" etc... with no results, When I convert to "UTF-8 without BOM" the symbols(words) (Ç and ë) are Ok in the web page, but if I insert them into mysql database using Mozilla Firefox, they are showed in database as ë, But if I use Internet Explorer to insert them into database everything it's ok.

p.s. I use Notenpad ++, and what is the standard format?

Re: Problem with some symbols(words) in Mozilla

Posted: Sat Oct 17, 2009 4:14 pm
by Jaxolotl
First of all, create a new document with utf-8 (NO BOOM - NEVE EVER EVER BOOM), then copy and paste the original code into it and overwrite the old one.

Now some questions that may guide you to find the solution.
  1. The server is sending the wright headers? if not force them by adding header('Content-Type:text/html; charset=utf-8'); just before your HTML output starts
  2. Is your html meta telling the browser about the wright charset? if not add <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  3. Is your database charset and collation properly assigned for the entire connection, db tables and db columns?
  4. Did you remember to add mysql_query("SET NAMES 'utf8'", $db_link); after the connection script but befor any other query?
I hope this helps you

Re: Problem with some symbols(words) in Mozilla

Posted: Sat Oct 17, 2009 4:41 pm
by MicroBoy
Thnx a lot, now everything it's ok.