From: Peter Brawley
Date: July 30 2005 2:58am
Subject: Re: Phone Number Column Advice
List-Archive: http://lists.mysql.com/mysql/187114
Message-Id: <42EAECC2.30402@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Scott Purcell wrote:

 >I am waffling on how to handle a column of phone numbers. I am
 >not sure what is common practice on the database side. Talking to
 >some co-workers, some feel it would be fine to use a varchar and
 >others think there should be 3 integer columns in the database
 >for each number?

Parts of some phone numbers begin with '0', which you can't represent as 
an INT, so use CHAR.

PB

>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005