Dipesh wrote:
When i equate the two string "abc" = "abc " that also matches. So is it a bug or it is designed like this?
Ann W. Harrison answers:
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.