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