voipfc ¼g¹D¡G

> 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.

if you are not sure the servers' settings, you can execute the query:

SET NAMES 'charset_name' COLLATE 'collation_name'
http://dev.mysql.com/doc/refman/5.0/...onnection.html

which make sure you are working with the correct settings.