Skip site navigation (1) Skip section navigation (2)

LIKE vs =

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 (view raw or flat)
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

Responses

sfpug by date

Next:From: Josh BerkusDate: 2004-08-23 17:42:17
Subject: Re: LIKE vs =
Previous:From: Josh BerkusDate: 2004-08-19 02:59:03
Subject: New meeting details up.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group