voipfc wrote:
> 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.

A collation sequence only effects collation, that is the order in which
data is returned when an ORDER BY clause is included in the SELECT.