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

Re: UTF-8 and LIKE vs =

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: David Wheeler <david(at)kineticode(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-23 20:22:01
Message-ID: 200408232222.01447.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-general
David Wheeler wrote:
> Any idea why = works here and LIKE and ~ wouldn't?

Because LIKE does a character-by-character matching and = uses the 
operating system locale, which could do anything.  If you set the 
locale to C, you should get matching results.  Which one is "better" 
depends on the semantics of the language, which I cannot judge here.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


In response to

Responses

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2004-08-23 20:27:34
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:From: BenDate: 2004-08-23 20:21:44
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions

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