ASCII and the scourge of lexial sorting.

A word from our sponsor:

The Breast Form Store Little Imperfections Big Rewards Sale Banner Ad (Save up to 50% off)

I suppose that there has always been a past. That every thing we live with has a history and that we we all have to deal with the consequences and the compromises that that past brought. There's an old aphorism that I learned from one of my more memorable mentors: "Yesterday's solution is tomorrow's problem."

If you are as old as I am or if you have read some history then you might recall that in the 1900's New York city had a terrible pollution problem. Every horse dropped 50 pounds of "apples" every day. And there were hundreds of thousands of horses in New York. There were articles in the paper talking about how the city could not survive the onslaught of manure much less the stench. A few years later the problem was solve. The automobile solved New Yorks' pollution problem. Fast forward to today. Yesterday's solution becomes tomorrow's problem.

ASCII is the American Standard Code for Information Interchange, It's some geeky detail down in the bowels of computer organization and architecture. It is the historical way that computers store letters, numbers, punctuation, white space and all those other little pictures on your screen. It's the American Standard because of squatting rights and despotic hegemony and industrial sabotage. And all those other historical adventures that brought us here. Pretty much it was once the most common way that computers knew how to deal with textual information.

It included lots of useful things. One was that it preserved compatibility with the standard that came before it. It also provided a simple way to sort American English words. And it was everywhere that there was a computer. So it was what was used.

ASCII has a petty serious problem when it comes to sorting though. Specifically when sorting numbers. While with letters it is not unreasonable for "aa" to come before "ab" and for "gh" to come before "gi". This is not usually true for numbers. With numbers '1' comes before '2' and '7' comes before '8' . But ordering numbers bigger than '9' is different. ASCII works great for ordering multi-letter words. But it is not so good for ordering numbers: 'Abbie' comes before 'Annie' and ASCII "does the right thing" but the same is not true of numbers: '2' comes before '10' in numbers but in ASCII Sorting we get confusing results. When sorting using ASCII rules we see that the order is '1', '10', '2'. That's confusing. That's a problem.

Technology can come to our rescue again. Technology can provide another way to sort our titles so that "wonderful story part 10" does not show up between "wonderful story part 1" and "wonderful story part 2". But extra steps have to be taken to make that happen. We need our technologists to find a solution to this crisis. I know that they are up to it.

---

Just to be doubly sure that we are all in on the joke. I'm writing the above with my tongue firmly planted in my cheek. Those who operate and maintain this website deserve all the highs praise as well as sufficient financial compensation. If ever there were people deserving of canonization it is them. I'd love to find some way to to provide in kind assistance.

Click Like or Love to appropriately show your appreciation for this post: