[RESOLVED] php charset PROBLEM

[TheStalker]

Ok so im not too sure if my problem is with PHP or MYSQL (so sorry if i have posted in the wrong place)

I have a big list of names from all round the world that need to be imported inot a mysql database. The problem im having is that when they are imported into the database some of the iwth special char such as acents etc dont look right and they are displaying wired chars.

Now atm i have the following at the top of my import page :
header('Content-Type: text/html; charset=UTF-8');

and have my table in my database set to utf8_general_ci

If anyone knows where im going wrong please could you advise ?

thanks
:quiet:

[NogDog]

This info may help: http://www.charles-reace.com/blog/2008/10/03/utf8-in-php-and-mysql/

[TheStalker]

thanks for the link that is a good read. I had tried some of those things already.

After some more google time i found this

mysql_set_charset('utf8',$con);

This seemed to do the trick.