Hi, > 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? > > Anyone have advice or know of best-practice on this subject?
Well, there was a long thread on this last week. Anyway, given that a phone-number IS NOT an integer (eg: leading zeros), it simply cannot be stored into a numerical column. Also, these days, you might have character-based phone-numbers: 0800-AOLUSA. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]