I am working on a MySQL 5.0 database that automatically sets the
default collation sequence to latin1_swedish_ci. It seems to be given
some accented characters and messing up the UK currency symbol.

The server is a shared hosting server and I don't think I can configure
my own settings

What is the default collation sequence should I use for trouble free UK
oriented work when creating a table?

Are there some additional settings I can use on the client side when
connecting? I am using PHP, Microsoft Access and SQLYog clients.