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.
- 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
- 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">
- Is your database charset and collation properly assigned for the entire connection, db tables and db columns?
- 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.