Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
>Hello,
>I am currently working on cleansing some horrific data. I need to store phone numbers (US and international). I usually use a 10 char field and strip out all special characters on the application side for US phone numbers. I've never worked with international phone numbers before. What's a good standard way of storing them?
>
>Thanks!
Upgrade to 20 Chars at least
(you can run into 13 digits on single lines, extension numbers are usually 4 digits, but have short numbers... leave headroom)
keep the originating data for checks
go for 4 to 6 columns (country, prefix [might split into cell and area] city, phone, extension and perhaps another column indicating other usages like fax)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement