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

Re: UTF-8 and LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-23 20:43:18
Message-ID: (view raw or whole thread)
Lists: pgsql-general
On Aug 23, 2004, at 1:22 PM, Peter Eisentraut wrote:

> 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.

Thanks. So I need to set the locale to C and then LIKE will work 
properly? How do I go about doing that? I can see these options:

String sort order

Character classification (What is a letter? The upper-case equivalent?)

Language of messages

Formatting of currency amounts

Formatting of numbers

Formatting of dates and times

Is one of these the one I need to set?



In response to


pgsql-general by date

Next:From: Ian BarwickDate: 2004-08-23 20:58:45
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Joshua D. DrakeDate: 2004-08-23 20:33:44
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions

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