I have a site based on Joomla 1.0.11. This uses Mysql 5 as its database backend.

The problem I have is that the site displays the pound sign (&pound as "AŁ". Im told this is a character set mismatch between the page joomla creates and the db.

If i set the page to UTF-8, the problem vanishes. Alas it causes more issues than it solves with other problems occuring that i just cant solve.

Rather than changing the page to UTF-8, is it possible to change my mysql DB to iso-8859-1 ? I notice that some of the fields/tables are in UTF-8 format, others in Latin1.

Can this be done ? If so how? (im a bit of a mysql ludite)