J. Michael Crawford wrote:
Encoding translations that didn't work:
a) Getting encoded bytes from the result set. We tried the following block five times, once for each different encoding we were trying to test with the database:
b) Getting a string, turning it bytes, and then translating. Same process as above, but we use result.getString...
No matter what, strings showed up as gibberish in one JVM or another, depending upon the native encoding of the database. A Latin1 database worked in the windows JVM, a Unicode in the Linux JVM, but not the other way around.
The "right way" is to just use getString() and not do any translation yourself. The driver has already done the transcoding from whatever the DB encoding is, to the internal UTF-16 string representation. You don't need to mess with byte-based representations.
When you then display that string, you will need to use an appropriate encoding, obviously..
Can you provide a self-contained testcase that demonstrates getString() doing the wrong thing?
-O
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
