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

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -