| From: | David Wheeler <david(at)kineticode(dot)com> |
|---|---|
| To: | SF PostgreSQL Users <sfpug(at)postgresql(dot)org> |
| Subject: | LIKE vs = |
| Date: | 2004-08-23 17:39:38 |
| Message-ID: | 689518E8-F52B-11D8-990D-000A95972D84@kineticode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
Hi All,
I'm having some trouble with multibyte characters and LIKE. We've been
using LIKE instead of = for string queries for a long time, as it gives
us flexibility to use wildcards such as "%" when we need to and get the
same results as with = by not using them. But I've just found that it
sometimes doesn't work properly:
bric=# select version();
version
------------------------------------------------------------------------
---------------------------------
PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
20030222 (Red Hat Linux 3.2.2-5)
(1 row)
bric=# select * from keyword where name = '북한의';
id | name | screen_name | sort_name | active
------+--------+-------------+-----------+--------
1218 | 국방비 | 국방비 | 국방비 | 1
(1 row)
bric=# select * from keyword where name LIKE '북한의';
id | name | screen_name | sort_name | active
----+------+-------------+-----------+--------
(0 rows)
Any idea why = works here and LIKE wouldn't?
TIA,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-08-23 17:42:17 | Re: LIKE vs = |
| Previous Message | Josh Berkus | 2004-08-19 02:59:03 | New meeting details up. |