Topic: Mysql Phone numbers (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=31830" title="Pages that link to Topic: Mysql Phone numbers (Page 1 of 1)" rel="nofollow" >Topic: Mysql Phone numbers <span class="small">(Page 1 of 1)</span>\

 
Hustluz
Bipolar (III) Inmate

From:
Insane since: Jun 2003

IP logged posted posted 05-25-2010 01:31 Edit Quote

My question is what is the best way to store a phone number with extension in a mysql database. Should it be a string or a int number?

Tyberius Prime
Maniac (V) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

IP logged posted posted 05-25-2010 08:56 Edit Quote

Certainly a string, or how are you going to encode +49 for a number in Germany in an int?

Keep in mind, you should impose formating rules on a phone number when outputting it.

So long,

->Tyberius Prime

chrisadam11
Neurotic (0) Inmate
Newly admitted

From:
Insane since: Sep 2010

IP logged posted posted 09-20-2010 13:51 Edit Quote

edit tp: spam removed

(Edited by Tyberius Prime on 09-20-2010 15:17)



Post Reply
 
Your User Name:
Your Password:
Login Options: Remember Me On This Computer
 
Your Text:
Loading...
Options: Show Signature
Enable Slimies
Enable Linkwords

« BackwardsOnwards »

Show Forum Drop Down Menu