utf8 & database problems
I'm working on software wich must support all possible languages. We have UTF-8 database wich is accessed via jdbc80520 driver, problem is that when fetching Strings they are UTF-8 encoded and need to be converted back to 'java strings'. Some examples suggest using following technique:
String coded = (get data from database)
String decoded = new String(coded.getBytes(), "UTF8")
Problem is that this doesn't work as expected, some characters are not properly translated and are presented as 0x3F in bytearray. String constructor seems to end string there when first 0x3F occurs so result is part of fetched string. I have already tried to making own getbytes .. but It didn't seem to work any better, actually it worked even worse.
Same problem occurs when with servlets and using UTF-8 as page encoding an gettin parameters (from a form). But once we configured orion (servlet engine) to use UTF-8 as default encoding, decoding request parameters was not needed anymore since req.getparameter gives correct string. Unfornattely database still gives UTF-8 decoded strings and it must be decoded ...
All information, solutions, links etc. are welcome :)
