| Subject | Re: UNIQUE INDEX and trailing blanks | 
|---|---|
| Author | Alexander V.Nevsky | 
| Post date | 2003-11-19T14:06:10Z | 
--- In firebird-support@yahoogroups.com, "Klement Guenther - Munich-MR 
- external" <gklement@m...> wrote:
varchars ignore trailing blanks except LIKE.
Best regards,
Alexander.
            - external" <gklement@m...> wrote:
> Why are trailing blanks ignored within varchars?CHAR.
> I think this should only apply to data types with fixed length eg.
> Is this a bug?Guenther, no, it is SQL standard. All comparisons of chars and
varchars ignore trailing blanks except LIKE.
Best regards,
Alexander.