Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What type to use for email and what size
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01196171
Message ID:
01196179
Vues:
9
>
>use varchar(100), I doubt that somebody will have 100 chars as eMail (who will wrote Him/Her?) but varchar keeps the data trimmed and there is no waste of space. :-)
>Keep in mind that you must pass the data trimmed from your FrontEnd.

100 is probably OK, but I've seen some incredibly long email addresses (mostly from US government agencies) before so I like to have enough space...
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform