I once had to deal with a DB (of my own creation, gone wild) that had three fields for the three parts of the NANP number. We wound up stuffing international into it by making the first field a varchar that allowed up to 8 or 9 digits, making the second field NULL allowed and making the last field a varchar that could hold up to 15 digits. Thus international numbers had a huge areacode and a huge local number and could be distinguished from NANP numbers by having a null NXX.

I am still worried about buring in hell over that one. Of course we were able to get away with minor perl changes and didn't have to change one script at all. Still, I'm pretty sure I owe a few coders beer just for not complaining louder in the meeting when they decided to do it.

--
$you = new YOU;
honk() if $you->love(perl)

In reply to Re: Re: Re: Question about phone number storage. by extremely
in thread Question about phone number storage. by rfb

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.