Still more confusing for me:

drop index index_a; /* see below */
insert into foo values('a');
insert into foo values('a ');
select * from foo where a='a ';

Should not find two records, should it?

>
> Why are trailing blanks ignored within varchars?
> I think this should only apply to data types with fixed
> length eg. CHAR.
> Is this a bug?
>
> Tested with Firebird 1.5 RC7
> Simple Testscript:
> create table foo ( a varchar(10) not null );
> create unique index index_a on foo (a);