charset problem between mySQL and php webpage?

I

Ing??r

New member
I?m gonna make this simple....

I?m making webpage (news page) in php with mySQL database (phpmyadmin)

I have a problem with charsets

When I add record in database all special characters appeared in the DB as a mess but I was
able to fix it with this script (mysql_query("SET NAMES utf8");

But in the news.php when looking at all the records, all the meshed up records turns out fine (with all special characters).... but the records that I could fix in the database appears as ? (question mark)

So this bad charset in DB appears normal
and normal charset in DN appears ?

Is there a way to fix this so both special characters appear fine in DB and in news.php

Or should I just trust that the bad characters in the DB will always turn normal on the webpage?
 
Back
Top