Re: Phone Number Column Advice

2005-07-29 Thread Peter Brawley
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 numbe

Re: Phone Number Column Advice

2005-07-29 Thread Asad Habib
Hello. I posted a similar question a while back and received a bunch of responses. It depends on how you plan to use the numbers. If you plan to use them in calculations, then storing them as INTs is best. Also, breaking a number into separate components makes sense if you plan to use these compone

Re: Phone Number Column Advice

2005-07-29 Thread Martijn Tonies
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 ad