Hello.
Yes, may be LIKE operator should check the type of column and
remove trailing spaces from the comparsion varchar-string, but in
TEXT columns trailing spaces are allowed.
Thomas Spahni <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> recently I encountered the following problem:
Thomas Spahni wrote:
Hi everyone,
recently I encountered the following problem:
SELECT COUNT(id) FROM sometable WHERE somevarchar LIKE 'thistext ';
returned 0 (of course!) because trailing blanks can't exist in a column of
type VARCHAR.
But: Shouldn't the constant be truncated automatically in this
Hi everyone,
recently I encountered the following problem:
SELECT COUNT(id) FROM sometable WHERE somevarchar LIKE 'thistext ';
returned 0 (of course!) because trailing blanks can't exist in a column of
type VARCHAR.
But: Shouldn't the constant be truncated automatically in this context
before t