MySQL Bugs: #2081: Character corruption

Bug #2081	Character corruption
Submitted:	10 Dec 2003 10:46	Modified:	10 Dec 2003 11:40
Reporter:	Andrew Spong	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S2 (Serious)
Version:	3.23.52	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
The £ character when it is inserted into a text column using the jdbc driver, is corrupted when it is retrieved using rs.getString()

How to repeat:
When the "£" (pound) character is saved into a text type field (invoice.comments) using the jdbc driver version mysql-connector-java-2.0.14-bin.jar
, it saves successfully. 

However, when it is retrieved 
using rs.getString("invoice.comments") it is corrupted into e.g ï¿½

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

This has been fixed for over a year in Connector/J 3.0.x.

In Connector/J 2.0.14 and earlier, the default character set was 'ascii'. You need to add 'useUnicode=true&characterEncoding=ISO8859_1' to your JDBC URL if you want to use what MySQL calls 'latin1'.