The most common phone number

Submitted by: Anonymous – Mon, 07/28/2008 – 12:18

Working on something this morning, I needed to know what the largest number is that can be stored in a 32-bit signed integer. A 10-digit number starting with "214". In other words, a Dallas phone number.

So, out of curiosity I Googled "214-748-3647" to see who has the number. After a handful of blogs noting the coincidence (and that it's a prime number), there are 1500+ websites with that phone number showing up. Why? Because some programmer somewhere didn't learn his lesson from Y2K, and decided to store phone numbers as a single integer instead of a string of characters, but only used 32 bits and didn't check for overflow. So any time someone enters a phone number that's larger than 2147483647, the system stores it as that Dallas number.

Somewhere in Dallas, some poor bastard is wondering why his phone rings off the hook with calls for the Nevada Division of Mental Health & Developmental Services, the Jackson County Florida Chamber of Commerce, a yacht club in New York.....

CAPTCHA: "surper" -- when a shark has a surfer for supper.

Comment:  common phone number

Unverified. A similar tale comes from some developers in Connecticut who worked on an automated juror selection program. The reasoned that you only needed seven characters to uniquely identify each town in that state. After a while someone noticed that NO jurors came from Hartford. It seems like the next field after the city name was whether or not the person was Alive or Deceased. As the last character in "Hartford" is a "D" the entire city was considered deceased and you are not supposed to have jurors that are no longer living. Some shortcuts have in intended consequences.

Anonymous – Mon, 07/28/2008 – 12:33

Comment:  Not Enough Spaces

A vendor tried to sell us an application for keeping trach of real estae. It was running successfuly elsewhere.
Problem was it was running only in small towns. What's wrong with that?
Well, everyone else in the room was very impressed with the system. After praises were sung I asked the vendor about the street name. Seems you only can enter six characters and there is no field for Street, Place, Avenue, Etc. When the vendor explained that six characters was al we got and we would have to give code names to many streets to differentiate them the meeting came to a quick end.
Its hard enough getting the data right without having data entry folk having to change it while entering.
BENTIP -- Pseky Uncle Ben has another hot stock for you.

Sphynx – Mon, 07/28/2008 – 15:39

Comment:  Hmmm, that's not gonna work

And I thought it was horsepucky when a mailer wanted us (USPS) to compress every address in the system (master addressing db) to 25 characters or less, including apt/ste numbers. Oy. After 20 years as more or less an addressing expert, 6 characters for a street name ranks as one of the dumbest things I've ever heard. BTW, USPS has a publication for address formatting if you ever need the info, it's Publication 28, "Postal Addressing Standards". Available on usps.com.

VAPBE-Various Architects Purchasing Belligerent Echidnas

Postal Data Guy (not verified) – Wed, 07/30/2008 – 06:39

Comment:  Program for the EXCEPTIONS to the rules!

Thanks for the tip, I downloaded that USPS publication, and searched for an exception to an addressing headache I discovered in my town. There's a house on a small court or cul-de-sac that has a house number of zero. Yes, good old placeholder, zip, zilch, nada, goose egg. The house number sign by the door spells it out as "ZERO", but when I spoke with the family living there, they said it did cause them some grief from time to time. Just for fun, my friend and I tried entering it in a GPS to ask for directions, and it wouldn't take it.

I know of at least three other weird addresses like it in our town. The best is probably the house with an address on one street, but the street ends before it gets there, not even a dirt or gravel path, just a grassy yard. You have to travel up a railroad service road to get to it.

walterego (not verified) – Fri, 08/01/2008 – 17:31

Comment:   Program for the EXCEPTIONS to the rules!

I retired from the USPS last year, and my office delivered mail to a former Air Force base.

When the base was being converted for civilian use and a developer was remodeling (rebuilding) several of the old hangers, the city approved addresses of Hanger 1 through Hanger 4, with no street information attached or required by the city. Of course, they didn't bother checking with the PO before they approved them, and it took the Address Management people at the district office about three months to figure out how to include those four addresses in the AMS database. And naturally the city didn't bother telling us about it until the buildings were ready to receive tenants. How do you tell a million dollar customer that his mail is not being delivered because USPS computers don't accept his address?

LateNightLarry – Fri, 08/01/2008 – 21:07

Comment:  Hartford is Deceased....

If Hartford were in Illinois, every person would have been registered as a qualified voter (vote early, vote often, vote as ghost)!

LOL

Anonymous (not verified) – Thu, 07/31/2008 – 09:54

Comment:  So unsigned...

These must not be software engineers doing this. Even unsigned the phone number be 429-496-7296.

Just FYI, since I worked in telecomm, switching systems represent telephone numbers as a strings of sort of hexadecimal numbers. I say "sort of" because the pattern is 0-9, *, #, A, B, C, D. The A-D were apparently used at one time for military applications, or so I'm told.

So anyway, my big gripe in the world are forms that admonish you and reject your input if you enter spaces or dashes when entering your phone number. Stupid software, if you don't like the dashes or spaces then take them out yourself!

Anonymous – Tue, 07/29/2008 – 14:07

Comment:  But I Like It Inconvenient!

We updated an old mainframe application twenty years ago. One of the data fields was the Social Security Number. We programmed it so you didn't have to put in the dashes, they would appear automatically. We were flooded with complaints from users who wanted to put in the dahses themselves. Go figure.

Sphynx – Wed, 07/30/2008 – 07:52

Comment:  RE: But I like it inconvenient

Years ago, the accounting system i worked with was the same way. You would enter telephone numbers, SSN's and even GL account numbers without any spaces, hyphens, etc.

A phone number would be entered as 9876543210

When it was time to display that number on a screen or print it on a form, there was the accompanying "display code" which formatted the number. I remember the display code for a phone number: "(XXX) XXX-XXXX" Thus the above number came out as: "(987) 654-3210". If one only used 7 digits, such as 6543210, it would be displayed as: "( ) 654-3210".

That system also had numeric display codes for such things as number of decimal places; thousands separator, suppression of leading zeroes, etc.

Fatman – Wed, 07/30/2008 – 09:07

Comment:  FYI

The original plans for Touch Tone included 4x4 keypad. The additional 4 buttons A,B,C,D were for command codes and would only be found on phone company employee phones. These tones were also a big part of the blue boxs used by phone phreaks. One of those tone was also recreated by the imfamous Capt. Crunch whisle.

There may also be military applications for the codes but I have no knowledge of that.

CAPTCHA CODG - The seventh cod catch of the day

"Illegitimi non carborundum"

Ravingmavin – Wed, 07/30/2008 – 08:29