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!
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
