It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes rs.getBytes() rarity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "rs.getBytes() rarity" Watch "rs.getBytes() rarity" New topic

rs.getBytes() rarity

Jonas Wille

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.


I agree. Here's the link:
subject: rs.getBytes() rarity
It's not a secret anymore!