Hi Ann,

Thanks for replying and informing about character set octets. I have
tried using this also but its not working for me.

I am using firebird 1.5.1

I guess only thing which i can do is to not index string in my table
and use LIKE.

Thanks!
Regards,

Dipesh

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

> 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
>