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

What exactly are you trying to achieve ? You want unique constraint
which treats 'abc' and 'abc ' as different strings ? It works if you use
character set octets. What do you mean by "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.

Why do you think you can't use index?

Ivan

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