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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
