Re: [GENERAL] Very weird problem of "order by" in postgresql

34 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Peter Cai" <[EMAIL PROTECTED]> writes: > > The only difference is that one OS is centos and the other is ubuntu > > It's hardly impossible that those two contain different locale > definitions. Have you

Re: [GENERAL] Very weird problem of "order by" in postgresql

_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= 2008/9/8 Peter Cai <[EMAIL PROTECTED]> > Still the same problem…… > > What I did is: > > 1.

Re: [GENERAL] Very weird problem of "order by" in postgresql

rt orders. > > to Quote > PostgreSQL uses the standard ISO C and POSIX locale facilities provided by > the server operating system > > > http://www.postgresql.org/docs/8.3/interactive/locale.html > > Message from "Peter Cai" <[EMAIL PROTECTED]>

[GENERAL] Very weird problem of "order by" in postgresql

Hi all, I have 2 postgresql running on linux on 2 different physical machines. Then I create 2 identical database on them, both using utf8 as server encoding and GBK as client encoding. But when I try to order by some query result with a column containing Chinese characters, the result is differ

Re: [GENERAL] Npsql is much faster than ODBC ?

Thanks. I have tried your program. But it seems that it has trouble with EUC_CN. It returns unrecoginzed value of empty columns. BTW: I've solved this problem. Every one using odbc on windows shuold read this mail: psqlODBC with Visual Studio 2005 and Connection Pooling for newbies