character set

[Disco_Dave]

Hi

We our having problems with our character set in our MySQL database, I'm unsure of how this problem started. Our host as tried to resolve this but have been unsuccessful, I'm wondering if any of you guys could help us with this.

We our getting these types of characters – in titles and before £ signs

Dave

[borbole]

What is the coallation character set to?

[Disco_Dave]

The current Collation set for our database is UTF8, our old server appears to have it set as Latin1.

This is the info our new server is giving us, I know nothing about MySQL other than how to back it up, It seems our old host as changed some tables for some reason.

Any help would great, or any pointers in the right direction :)

Dave