[CentOS] Re: Problem of "sort" utf8 file.
Tom G. Christensen
tgc at statsbiblioteket.dk
Tue Sep 9 07:05:45 UTC 2008
Peter Cai wrote:
> PS: the background of this problem is that Postgresql's "order by"
> command depends on the sort result of the OS.
AFAIK PostgreSQL will determine its own locale from the system locale
when it's initdb'ed for the first time, that locale will then be used
for all databases even if you later change the system locale.
Perhaps you need to dump your databases and do a new initdb with the
proper locale set before this starts working the way you want.
More information about the CentOS