Convert MySql Database to be UTF-8 character encoding.
Mysql 4 onwards allows for the use of the much superior unicode character encoding. This removes a lot of the problems associated with the storage and transmission of Welsh and other languages with 'special' characters that do not appear in the default latin character set.
From MYSQl5 onwards you can use a simple command to quickly convert.
To convert the database simply run the following command for each table you wish to convert.
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8;