Problem with characters

[Critters]

I have a new setup with mySql version 4.1 and myODBC version 3.51 
running on Windows 2k3 standard

In the database we have something like "And this is £200" and when we 
write this out in ASP we get "And this is ?200" The same happens for 
some other symbols like the copy write symbol (c in a circle)

Any ideas? I have googled this for almost an hour now and never had this 
problem on other installs.
--
Dave