Subject | Re: [firebird-support] Re: LIKE statement using a SINGLE white space character |
---|---|
Author | Bruno Marx |
Post date | 2008-11-20T14:30:41Z |
You were right Heiko: the column type is CHAR and the query works
properly. The fact that the column is buffed with space characters
causes the query to catch all records that do not completely use the
column size...
Tks,
Bruno
properly. The fact that the column is buffed with space characters
causes the query to catch all records that do not completely use the
column size...
Tks,
Bruno
On Wed, Nov 19, 2008 at 1:57 PM, tdtappe <tappe@...> wrote:
> What type of column is it? Maybe CHAR? Then I'd say the result is
> correct. CHAR columns are kind of "filled up" with spaces.
>
> --Heiko
>
>