Search Postgresql Archives

Re: lc_collate issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Cody Pisto <cpisto@xxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux