Cody Pisto <[EMAIL PROTECTED]> 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
