Why does the ResultSet.getCharacterStream().read method return an int instead of a Character?
It seems that that requires me to make the conversion of a number to a character, which aside from being error-prone, bypasses all the great character set translation stuff built into
Java, doesn't it?
I'm interested in this topic mostly because I've got a problem with a
JDBC driver returning question marks for certain extended characters and it seems like it has something to do with the number-to-character conversion.
Any insight, particularly on ways to make the conversion correctly, would be appreciated. I've got windows-1252 characters from Windows machines being stored as UNICODE characters (MS Access 2000; memo field) and they seem to be getting converted when they go through my
servlet and JDBC driver to ISO-8859-1 characters. So many extended charcters, like the en- and em-dash characters, get turned into question marks.
Dave