Re: sorting problem

I create a new database use UTF-8 and SQL_ASCII, same result found, how
can i fix this problem ?

CK

Kevin Grittner wrote:
>>>> CK Leung <ck@wecity.com> wrote:
>>>>
>> the result : select * from tt order by item_code;
>>
>>       item_code
>> ----------------------
>>  VAAAA
>>  .VAAAA
>>  V.AAAA
>>  VA.AAA
>>  V.AAAAB
>>  VBBBB
>>  (VBBBB
>>  (V)BBBB
>>  (V)B.BBB
>>  (VB)BBB
>>  V.BBBB
>>  V)BBBB
>>  VCCC
>> (13 rows)
>>
>> the sort sequence like ignore the character '.' , '(', ')'. Is it a
>> bug ?  It is no problem in old version !!!!
>>
>
> Probably not a bug; many collating sequences are defined to ignore
> such characters.  Perhaps you chose a different locale when you
> converted?
>
> -Kevin
>
>