Обсуждение: BUG #1856: chinese sort error

Поиск
Список
Период
Сортировка

BUG #1856: chinese sort error

От
"tk"
Дата:
The following bug has been logged online:

Bug reference:      1856
Logged by:          tk
Email address:      tk@cstramp.com
PostgreSQL version: 7.0.3
Operating system:   linux
Description:        chinese sort error
Details:

chinese sort error,中文排序不对,
如果一个表中有一个字段是中文,用

select * from tab order by col1
的时候,如果col1字段有中文,不能按照正确的ascii码对该å
­—段排序

Re: BUG #1856: chinese sort error

От
"Qingqing Zhou"
Дата:
""tk"" <tk@cstramp.com> wrote >
> The following bug has been logged online:
>
> Bug reference:      1856
> Logged by:          tk
> Email address:      tk@cstramp.com
> PostgreSQL version: 7.0.3
> Operating system:   linux
> Description:        chinese sort error
> Details:
>
> chinese sort error,中?‡æ?序ä?对ï?
> 如æ?一个表中æ?一个å?段是中æ?,用
>
> select * from tab order by col1
> ?„æ—¶?™ï?如æ?col1字段?‰ä¸­?‡ï?不能?‰ç…§æ­?¡®?„ascii?å¯¹è¯¥å
> ?段æ?åº?
>

Can you provide with a self-contained test case?

Regards,
Qingqing