Hi all, I have 2 linux distro ?? ubuntu and centos. My problem is that the sort command has different behavior when sorting Chinese string encoded in utf8 file. On Ubuntu, it is OK. But on CentOS, it WRONG. I google this problem and it seems that's because of LC_COLLATE. So I change "/etc/sysconfig/i18n" on CentOS and now the 2 have the same LC_** like this: CentOS: ============================[root at localhost ~]# locale LANG=zh_CN.UTF-8 LC_CTYPE=zh_CN.UTF-8 LC_NUMERIC="zh_CN.UTF-8" LC_TIME="zh_CN.UTF-8" LC_COLLATE=zh_CN.UTF-8 LC_MONETARY="zh_CN.UTF-8" LC_MESSAGES="zh_CN.UTF-8" LC_PAPER="zh_CN.UTF-8" LC_NAME="zh_CN.UTF-8" LC_ADDRESS="zh_CN.UTF-8" LC_TELEPHONE="zh_CN.UTF-8" LC_MEASUREMENT="zh_CN.UTF-8" LC_IDENTIFICATION="zh_CN.UTF-8" LC_ALL Ubuntu ============================peter at ubuntu:~$ locale LANG=zh_CN.UTF-8 LANGUAGE=zh_CN:zh LC_CTYPE="zh_CN.UTF-8" LC_NUMERIC="zh_CN.UTF-8" LC_TIME="zh_CN.UTF-8" LC_COLLATE="zh_CN.UTF-8" LC_MONETARY="zh_CN.UTF-8" LC_MESSAGES="zh_CN.UTF-8" LC_PAPER="zh_CN.UTF-8" LC_NAME="zh_CN.UTF-8" LC_ADDRESS="zh_CN.UTF-8" LC_TELEPHONE="zh_CN.UTF-8" LC_MEASUREMENT="zh_CN.UTF-8" LC_IDENTIFICATION="zh_CN.UTF-8" LC_ALL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ But, the result is still incorrect on CentOS! I almost got crazy!!! PS: the background of this problem is that Postgresql's "order by" command depends on the sort result of the OS. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080909/45ff9df4/attachment-0002.html>
localedef -f UTF-8 -i zh_CN zh_CN.UTF-8 Nothing happened. ---------- Forwarded message ---------- From: Peter Cai <newptcai at gmail.com> Date: Tue, Sep 9, 2008 at 9:42 AM Subject: Problem of "sort" utf8 file. To: centos at centos.org Hi all, I have 2 linux distro ?? ubuntu and centos. My problem is that the sort command has different behavior when sorting Chinese string encoded in utf8 file. On Ubuntu, it is OK. But on CentOS, it WRONG. I google this problem and it seems that's because of LC_COLLATE. So I change "/etc/sysconfig/i18n" on CentOS and now the 2 have the same LC_** like this: CentOS: ============================[root at localhost ~]# locale LANG=zh_CN.UTF-8 LC_CTYPE=zh_CN.UTF-8 LC_NUMERIC="zh_CN.UTF-8" LC_TIME="zh_CN.UTF-8" LC_COLLATE=zh_CN.UTF-8 LC_MONETARY="zh_CN.UTF-8" LC_MESSAGES="zh_CN.UTF-8" LC_PAPER="zh_CN.UTF-8" LC_NAME="zh_CN.UTF-8" LC_ADDRESS="zh_CN.UTF-8" LC_TELEPHONE="zh_CN.UTF-8" LC_MEASUREMENT="zh_CN.UTF-8" LC_IDENTIFICATION="zh_CN.UTF-8" LC_ALL Ubuntu ============================peter at ubuntu:~$ locale LANG=zh_CN.UTF-8 LANGUAGE=zh_CN:zh LC_CTYPE="zh_CN.UTF-8" LC_NUMERIC="zh_CN.UTF-8" LC_TIME="zh_CN.UTF-8" LC_COLLATE="zh_CN.UTF-8" LC_MONETARY="zh_CN.UTF-8" LC_MESSAGES="zh_CN.UTF-8" LC_PAPER="zh_CN.UTF-8" LC_NAME="zh_CN.UTF-8" LC_ADDRESS="zh_CN.UTF-8" LC_TELEPHONE="zh_CN.UTF-8" LC_MEASUREMENT="zh_CN.UTF-8" LC_IDENTIFICATION="zh_CN.UTF-8" LC_ALL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ But, the result is still incorrect on CentOS! I almost got crazy!!! PS: the background of this problem is that Postgresql's "order by" command depends on the sort result of the OS. -- ?????????????????????????????????????????????????????????????????????????????????????????? -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080909/2af43df1/attachment-0002.html>
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