I've just converted a database from Access to MySQL.
I have a field in the database which includes characters such as £, but when they are displayed on the web page they come out as ﾣ. The data type for the field in MySQL is 'text'.
Is the data type correct or should I convert special characters within coldfusion?
Thanks in advance.