Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

rs.getBytes() rarity

 
Jonas Wille
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic