Erwin Brandstetter <brandstetter@xxxxxxxxx> writes: > Wait .. not that great! The system locale is more or less ignored, but > my sort order will approach randomness? Peter's point is that a given locale setting will expect a particular encoding, and if you try to use a different encoding then your sort ordering will be wrong. Not "random" exactly, but not what you want. regards, tom lane