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 <c...@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
