db2,char for bit data,compare -


a field in java type guid. in db2 type char data type. don't understand why (x'00345c9101600000018323b4f1311964bb' < x'00345c9101600000018323b4f1311964bb01') false. not comparation of hexadecimal? help.

since sql data type character, string comparison rules apply, shorter string padded spaces on right. ascii code space character x'20', greater x'01'.


Comments

Popular posts from this blog

javascript - WinJS appendTextAsync producing scheduler errors -

minify - Minimizing css files -

Sockets with kotlin -