Re: blank in query - cannot return results - Mailing list pgsql-general

> Hello,
>
> PostgreSQL 8.3.18  on x86_64-linux-gnu, query:
>
> select * from table_name where col1 =    'Abc, test';
> select * from table_name where col1 ilike '%Abc, test%';
>
> NO result returned.
>
>
> But run:
> select * from table_name where col1 ilike '%Abc,%test%';   -- remove
> blank
>
> Result is returned.
>
>
>
> PSQL terminal encoding: unicode (UTF-8). From both terminal and db,
> values shows/and displayed as "Abc, test".
>
> But " " space/blank in where section cannot return query result.

    One more comments, for all non letter/numbers such as "-, ." in the
query won't return any results.
>
> Can someone tell why may cause the issue please?
>
> Thanks a lot!