-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Subject: Re: Phone Number Storage
>From: "Sujay Koduri"
>> I guess anywhere we have 3 levels of hierarchies for a phone number.
>> (Country code, Area code and the actual number).
>
>That&
From: "Sujay Koduri"
> I guess anywhere we have 3 levels of hierarchies for a phone number.
> (Country code, Area code and the actual number).
That's a pretty wild guess IMHO. You have to be absolutely sure that this is
true for each and every country in the world. Furthermore, various telecom
pr
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 nu
oduri [mailto:[EMAIL PROTECTED]
Sent: Monday, July 25, 2005 4:23 PM
To: Joerg Bruehe; mysql@lists.mysql.com
Cc: Asad Habib
Subject: RE: Phone Number Storage
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
-Original Message-
From: Joerg Bruehe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 1:34 AM
To: mysql@lists.mysql.com
Cc: Sujay Koduri; Asad Habib
Subject: Re: Phone Number Storage
Hi!
Sujay Koduri wrote (re-ordered):
> -Original Message-
> From: Asad Habib [mailto:
Hi!
Sujay Koduri wrote (re-ordered):
-Original Message-
From: Asad Habib [mailto:[EMAIL PROTECTED]
Sent: Monday, July 25, 2005 11:53 PM
To: mysql@lists.mysql.com
Subject: Phone Number Storage
Is it better to store phone numbers as strings or as integers? Offcourse,
storing them as int
I think it is better to store the phone numbers as strings only. As phone
numbers may also include '-', if you allow entering international numbers,
it is good to store them as strings only.
Or you can ask the area code and the actual number seperately and store them
seperately in two columns as
