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

Re: UTF-8 and LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: twanger(at)bluetwanger(dot)de, barwick(at)gmail(dot)com,pgsql-general(at)postgresql(dot)org, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>,Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-26 16:41:07
Message-ID: BA783DCA-F77E-11D8-BD80-000393D9369E@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-general
On Aug 25, 2004, at 7:35 AM, Lincoln Yeoh wrote:

> IMO I suggested the default to be C, and I still think that's the best 
> default. But of course that's just my opinion.

I agree.

> What would be useful would be functions to allow selects etc to be 
> ordered as if under different query specifiable locales.

Wouldn't that require different indexes for the different locales? 
(Where there are indexes, of course.)

> In this case which locale should you pick for initdb? I'd say C.

I did. Is that the same as --no-locale?

Regards,

David


In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-26 16:47:24
Subject: Re: R: R: space taken by a row & compressed data
Previous:From: David WheelerDate: 2004-08-26 16:39:23
Subject: Re: UTF-8 and LIKE vs =

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