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
>
>