|
The default sort order for character data is by hex value. In EBCDIC, the digits 0-9 are hex values x'F0'-x'F9', which puts them at the end of the sort, after the alphabetic letters. However, in ASCII, the digits are x'30'-x'39', while the letters start at x'41'. Therefore, in ASCII, the digits come BEFORE the letters in ASCII. This has been an issue in ASCII/EBCDIC since the olden days. Welcome to the wonderful world of distributed processing... <wry grin> Joe > -----Original Message----- > From: Angela Wawrzaszek > > I have a 2 position text field that I am sorting by. The codes > go from AA, > AB...A1, A2... BB, B1 etc. We are sending this to a sql server. > When they > sort it, the order is A1, AA, ...B1, BB The numerics are taking > precedence. They say it is sorting ascii. I thought ascii sort was > alpha/numeric also???
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.