Character set problem
Posted on 2006-11-02
porting an existing application to a new server with MySQL 5, when retreiving data from MySQL through Connector/J, I have encountered a weird problem: the character 0x92 (closing quote), which is correctly stored on the db, is retrieved by the jdbc driver as three characters: "â€™" (0xe2,0x80,0x99). The other characters, such as accenter letters, are retrieved correctly and rendered in html as ISO-8859-1.
I couldn't manage to figure out how to solve this problem in any way, so I decided make a text replace:
but it seems not to match the three character sequence correctly.
Can anybody help me with this, or better figure out how to solve the problem at its source?