Re: Call for an API standard for SQL statements
Date: 22 Oct 2004 22:25:29 -0700
Message-ID: <31f7e57d.0410222125.f8ca2a3_at_posting.google.com>
"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote:
> Next, is area code a concept that applies universally to all the countries?
Does someone claim this is the fact? Many applications are onyl made
for one specify county.
> Or it's just some prefix, that may have or might not have any meaning at
> all? Now that VOIP providers are increasingly becoming much more flexible
> with numbering system, the area code have no much sence to them any more.
TelephoneNo is just an examples. There are a lot of other examples
like Social security number, order id, employee number, etc, etc.
> Since data in the database are long lived, doesn't it make more sence to
> store the bare information -- a string of numbers -- rather than the
> information decorated with some short lived and arbitrary methods?
Yes, the telephone number should be stored in a database as a VARCHAR.
But in the application it should be uses as an instance of
TelephoneNo.
Fredrik Bertilsson
http://butler.sourceforge.net
Received on Sat Oct 23 2004 - 07:25:29 CEST