Pounds Signs (£) being displayed as Question Marks (?)
Posted on 2006-03-31
I am writing an applcation using the Apache Struts Framework with a MySQL database.
There is a field in the database which holds text which users would often inlude a pound sign (£) as part of the text. This is stored ok, as I have looked at the data using the MySQL Query Browser. The problem is that when the data is read back from the database, any pound signs are replaced with a ? when output to the system console (and a y with an accent if it is output to the JSP).
I've had a read around and I think this is something to do with character encoding, but I might be wrong since all the fixes I've tried so far have been unsuccessful.
Cheers for any help,