I have an issue with the £ character using CF8 and MySQL. Can anyone help?

Everthing was fine when using an Access Database but now I have swutched to MySQL all the £ charachters have changed to 'ﾣ'.

Even new entries in the Db switch the £ to a 'ﾣ'.

I have tried different character sets etc. but to no avail. Can anyone help?

This topic has been closed for replies.

Participant

Every other charachter works: $%&@ etc.etc. just not the £!

Inspiring

I think you'll find it's any non-ASCII characters that are bung.

Google "mysql jdbc utf-8" and you'll find the connection string you need to use on the datasource to make it UTF-8-aware.

--

Adam

Sign up