Subject | UNIQUE INDEX and trailing blanks |
---|---|
Author | Klement Guenther - Munich-MR - external |
Post date | 2003-11-19T09:39:29Z |
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);
insert into foo values('a' );
insert into foo values('a ');
/*or try this*/
insert into foo values(' ');
insert into foo values(' ');
------
Regards
Guenther
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);
insert into foo values('a' );
insert into foo values('a ');
/*or try this*/
insert into foo values(' ');
insert into foo values(' ');
------
Regards
Guenther