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 integers. sujay -----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 integers saves space but this requires extra processing of the user's input (i.e. CPU time). Are there any other advantages/disadvantages of doing it one way or the other? - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]