Tweet
** This thread discusses the article: TechTip: Compacting a Large Number into a Small Space **
"•Left-justified Base 36-encoded numbers do not sort, especially in EBCDIC! Convert the Base 36 to decimal/integer to sort correctly."
Just like left justified Base 10-encoded numbers do not sort... right justify the data and problem is solved - no need to convert it back and forth just for purposes of sorting.
"•Left-justified Base 36-encoded numbers do not sort, especially in EBCDIC! Convert the Base 36 to decimal/integer to sort correctly."
Just like left justified Base 10-encoded numbers do not sort... right justify the data and problem is solved - no need to convert it back and forth just for purposes of sorting.