Re: sorting problem

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