Dipesh wrote:

>
> When i equate the two string "abc" = "abc " that also matches. So is
> it a bug or it is designed like this.
>

The SQL standard specifies that trailing blanks in string fields
are not significant in equality matches and the index uses equality
matches. LIKE follows different rules. If you want to differentiate
between "abc" and "abc ", define the field as character set octets.



Regards,


Ann