On Thu, 8 Apr 2004, Tom Lane wrote: > Yup, exactly. If we did not force both LC_COLLATE and LC_CTYPE to have > the same values cluster-wide, then we *would* have index corruption > issues.
We really show warn people that using another encoding in a database then what the cluster uses, breaks sorting. I was under the impression that as long as I've set the right locale when doing initdb I could then create different databases with different encodings and it all works, but it does not. I simply trust pg too much (not without reason since it is an amazing project). -- /Dennis Björklund ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend