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