wood burning stoves 2.0*
The moose likes JDBC and the fly likes rs.getBytes() rarity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "rs.getBytes() rarity" Watch "rs.getBytes() rarity" New topic
Author

rs.getBytes() rarity

Jonas Wille
Greenhorn

Joined: Mar 29, 2010
Posts: 4
We have a RDB database with one column in utf-8 encoding for Chinese text. Now I want to know how many bytes the text takes. Well, we know how much it takes, but we want to see it in software.

So, I use the getBytes()-method of the ResultSet. For all Chinese characters it returns 2, but I doubt this is correct because when I use the getString().getBytes() of the ResultSet it returns 3 and with the SQL function LENGTHB() the result is also 3.

Finally, I try to make a String from the bytearray that is returned by the getBytes()-method of the ResultSet and compared it with the one that is returned by the getString() from the ResultSet.
If the text isn't Chinese, the 2 Strings are equals. But otherwise they aren't.


Is it possible that the getBytes() method of the ResultSet isn't correct? (Driver is a JDBC-RDB driver)

Hope you can understand what i'm trying to say.


output

 
Don't get me started about those stupid light bulbs.
 
subject: rs.getBytes() rarity