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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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