posted
I've got a MySQL 4.1 server running that I'm accessing with JDBC using the MySQL provided Connector/J 3.1 classes.
I'm having problems with some characters in sotred strings being turned into '?' when I'm retrieving them. So something like "‘life dilemmas’" turns into "?life dilemmas?". As you can imagine, this is pretty annoying.
They are all being inserted into the database correctly and are correct in the database and when retrieved using the MySQL Control Center gui. It's just when I get them with a JDBC query that they're getting corrupted/translated.
I figure it's a character set issue, as all the characters I'm having this problem for are non-standard, but I can't figure out how to fix it.
I've tried changing the character set when I open a connection using the DriverManager so that it looks like this:
Properties props = new Properties(); props.setProperty("charSet","windows-1250"); dbConn = DriverManager.getConnection(urlString, props);
I've used "utf-8", "iso-8859-1", "iso-8859-2", and "windows-1250" for the character set property.
I also changed the MySQL URL string used for connecting so that it adds the useUnicode=true property. But still no dice.
Does anyone know how I can go about solving this?
Posts: 10177 | Registered: Apr 2001
| IP: Logged |
Printer-friendly view of this topic
![[Smile]](smile.gif)
