By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

ORDER BY and case DB2 8.1.5 LINUX

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.