Apparently the order for mixed case is a, A, b, B ... which is somewhat
more than a little surprising. How do I make it the ASCII sort order (A,
B, ... Z, a, b, ... Z)? Where is the sort order defined in the (huge)
manual set?

Bob Stearns wrote:
> Apparently the order for mixed case is a, A, b, B ... which is somewhat
> more than a little surprising. How do I make it the ASCII sort order (A,
> B, ... Z, a, b, ... Z)? Where is the sort order defined in the (huge)
**********************| - THIS SHOULD BE z
> manual set?

Term you want to search online documentation (available at:
http://publib.boulder.ibm.com/infoce...help/index.jsp)
is collating sequence

User defined collating sequences are described in Application Development Guide:
{Programming Client Applications).

Note that collating sequences are defined at CREATE DATABASE time and cannot be
further changed.

Jan M. Nelken

If it is difficult to re-create a Database or you want temporary change
the order, please try:
ORDER BY HEX(order_column)