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.