PHP MySQL accents lost

Dude0

Hello

I have a script wich takes data out of the database. However some of that data has accented words (example: é) and those are getting translated to strange characters. The rest of the page with accents is ok (the data that isnt in the database).

Using mozilla and changing the char encoding to unicode makes the data from DB work ok and the plain text from the file gets the weird characters. So probably the tabels of the database need to be modified.

How can that get done?

Thanks.

Roger_Ramjet

character set and collation

Dude0

Hello,

tried some stuff. Here's some more info.

This happened when transfering the data to the other server
The SQL generated with PHPMyAdmin was rejected at the server (didn't recognise the collaction command)
Tried sending SET NAMES UTF8 after mysql_select_db and before mysql_query with no result. Also SET CHARACTER SET UTF8 was tried with no result.
The data in the server seams ok. Tried to access it with MySQL Query and sent some selects for wich the data was shown properly in Query program.
mysql_client_encoding returns 'latin1'

Thanks for your comment.