On Jul 25, 2005, at 1:23 PM, Sujay Koduri wrote:
I guess anywhere we have 3 levels of hierarchies for a phone number.
(Country code, Area code and the actual number).
The advantage of seperating them into different columns(Either an
integer or
a string) is that he can group different phone numbers based on
area code or
country code.
The key issue is less separating them into columns, but more one of
global use... As Joerg was saying, many countries have area codes or
even phone numbers that start with a zero - 0. If you store phone
numbers as an integer the leading zero will be dropped, thus meaning
you are storing incomplete data.
It does also in most applications make sense to store the area code
and country code as separate strings... but don't fall into the trap
of thinking a zero at the front of a phone number or an area code and
even some country codes isn't important.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
