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

Re: UTF-8 and LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Joel <rees(at)ddcom(dot)co(dot)jp>
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-31 00:39:57
Message-ID: 4875304A-FAE6-11D8-A2D5-000393D9369E@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-general
On Aug 30, 2004, at 5:34 PM, Michael Glaesemann wrote:

> Just a wee thing, and perhaps not the point of the post, but collation 
> is not important only for indexes. (Actually, I wouldn't be surprised 
> if some indexes are not necessarily ordered, but that may be my 
> inexperience talking.) You don't need an index on column foo to be 
> able to ORDER BY foo.

Yes, I know that. I guess I should've left mention of indexes out of 
it. I was still thinking in terms of my original issue, where a query 
for a particular string found no results when it should have because 
the index was using the en_us.utf8 locale.

Regards,

David


In response to

pgsql-general by date

Next:From: Tatsuo IshiiDate: 2004-08-31 01:06:21
Subject: Re: Hebrew support -- please help !
Previous:From: Michael GlaesemannDate: 2004-08-31 00:34:29
Subject: Re: UTF-8 and LIKE vs =

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