Re: Problem of "sort" utf8 file.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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.

-tgc

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux