Subject Re: UNIQUE INDEX and trailing blanks
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Klement Guenther - Munich-MR
- external" <gklement@m...> wrote:
> 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?

Guenther, no, it is SQL standard. All comparisons of chars and
varchars ignore trailing blanks except LIKE.

Best regards,
Alexander.