Re: lc_collate issue - Mailing list pgsql-general

From Tom Lane
Subject Re: lc_collate issue
Date
Msg-id 24663.1188004715@sss.pgh.pa.us
Whole thread Raw
In response to Re: lc_collate issue  (Cody Pisto <cpisto@rvweb.com>)
Responses Re: lc_collate issue  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-general
Cody Pisto <cpisto@rvweb.com> writes:
> If initdb was done with a C locale, and thus lc_collate and friends
> where all C, but the database and client encoding was set to UTF-8,
> would postgres convert data on the fly from UTF-8(storage) to ASCII for
> sorting or would things just blow up when a >1 byte character hit the mix?

No, C locale just sorts the bytes.  It won't "blow up".  Whether it will
give you a sort ordering you like for multibyte characters is a
different question.

            regards, tom lane

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Can tsearch do some basic text mining
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views