Tel

[lord_icon]

Greetings,

There are lots of convensions. Though wich is the generally most accepted way of storing telephone numbers? Because of the varient convensions, do I store the area code / std (uk) with the line number or do I just bin the area / std code? How do I store it, the datatype? Do I just have a 999999 for the number and bin the code ??
TIA
Regards

 

[gcampbell]

Personally I'd store it as a character field and then give the user the ability to set their accepted format. Then whenever you add a phone # field to your UI you need to set the FORMAT attribute to whatever the user has set for their format.

Later,
Gordon