Обсуждение: Bizarre sort order

Does anyone think this is the correct behavior?

adaps_db=# select * from upc_usage order by 1 ; usage
----------53EABCCYPHER_GENERALH66HAWK_JOERSRAS61S65S70S76S92XWING
(14 rows)

It appears to be ignoring the underscore!

Database has LATIN1 encoding and was recently migrated from 8.0 to 8.3.

"Conlon, Joseph F          SIK" <JConlon@SIKORSKY.COM> writes:
> Does anyone think this is the correct behavior?

If you don't think so, you need to change to C locale.
        regards, tom lane