Hi,

I am storing strings in the database table and indexing them. (all
of them are less than 252 characters). Now if have the following
string already in the table
"abc"
and i try to insert another string "abc " which is differnt than
what is there in the database, it does not allow me to put that in the
database.

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

If I have strings like that and i want to insert it into the
databsae how do i solve this problem.

If I use LIKE then it works fine but the trade off will be i don't
have to use indexing then which will be big loss i suppose.

Any help to solve this will be appreciated.
Thanks!
Regards,
Dipesh