Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From David Wheeler
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id BA783DCA-F77E-11D8-BD80-000393D9369E@kineticode.com
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Responses Re: UTF-8 and LIKE vs =  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List 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


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: "Leonardo Francalanci"
Date:
Subject: R: R: space taken by a row & compressed data