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)
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|