In the case of non-padded comparison semantics two values are compared
character by character up to the first character that differs. The value with
the greater character in that position is considered greater. If two values
of different length are identical up to the end of the shorter one, the longer
value is considered greater. If two values of equal length have no differing
characters, then the values are considered equal. Oracle uses non-padded
comparison semantics when one or both values in the comparison have the
data type varchar or varchar2.