var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 automatically trims on compare
Is it proper for DB2 to automatically trim whitespace on a compare.
select * from temp where name = 'TEST NAME'
select * from temp where name = 'TEST NAME '
Both of these return the same thing. In this example it isn't a big deal, but is it proper for DB2 to assume that the value should be trimed?
It is padding, and not trimming .. ie, if two strings of unequal lengths are to be compared, then the shorter string is padded with blanks to the right ...
If the field is a CHAR field, then db2 stores a shorter lenght field padded with blanks to the right ... So, anyways the strings are the same ..
If you are using VARCHAR, then the workaround is to say
select * from temp where name = 'TEST NAME ' and length(name)=length('TEST NAME ')
Visit the new-look IDUG Website
, register to gain access to the excellent content.