Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Varchar(max) vs Varchar(400)
Message
 
À
29/08/2013 11:20:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 6.5 and older
Application:
Web
Divers
Thread ID:
01581593
Message ID:
01581716
Vues:
70
>But given that an email address is only useful if it is valid, you need to at very least use a regex validation (this is true even for the 99% that only have one address.)
>

Only one caveat - regex on e-mail addresses - "thar be dragons!" - The rules around valid e-mail addresses are really complex. You want to err on the side of just basic sanity checking (has some text before the @, some text after the @ that includes a period); anything more probably won't work and you'll "fail" a perfectly valid e-mail address.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform