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