Subject Re: [firebird-support] Re: LIKE statement using a SINGLE white space character
Author Bruno Marx
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


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
>
>