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
Post a Comment