Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay123
Yak Posting Veteran
54 Posts |
 Posted - 2010-05-09 : 08:31:40
|
| Is there a list anyware(i cant find one) of common sizes for columns.Something like name columns should geraly be this sixeor e-mail columns should be this sizeExample:name columns should be varchar(30)email columns should be varchar(50)Just something to make sure all lenghs are enough.Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-09 : 17:31:49
|
Good question!I work on the basis of Name / Address being able to fit on the labels we use, and restricting the length to the width of the label (the user can, after all, manually split the address across the multiple lines.I have a very long email address, sites that cannot accommodate my email address lose my business - and it happens several times a year, so I would err on the side of over-kill on that.What about telephone number? Users, when permitted, will put all sorts of wibble in there (good & bad of course  ) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Common Sizes for table columns.