>>> CK Leung <ck(at)wecity(dot)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