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 |
|
travisl
Starting Member
12 Posts |
 Posted - 2004-07-01 : 12:03:42
|
| Probably in every database I've created, a field such as "address_city" has been varchar(50). It's the default in the UI, it doesnt seem overly big, and certainly not too small. I go with it. 50 might even be the number I'd use if I were to devote thought to figuring out what it "should" be.But I wonder... is there a list anywhere, of what a lot of smart people consider to be the right size for a field like that? I'd really like to standardize, and I'd like to know that the standards I choose make sense to someone besides myself :)Can anyone point me to a reference? I realize it's no universal thing, but I'm just entering this thought-space, to learn.Thanks,TravisTravis |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-01 : 12:35:10
|
| I'd like to know the answer to that too. We don't use as wide as 50 for individual lines of an address 'coz they don't fit on standard labels then!Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-01 : 18:41:01
|
| Well, if you go to the www.usps.gov website and rip through the source code, the maximum length for a city is 28.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
travisl
Starting Member
12 Posts |
Posted - 2004-07-01 : 18:43:41
|
| LOL, thanks Derrick, but.... I was just using that field as an example. It seems like there should be a list somewhere that shows a bunch of standards like this..Travis |
|
|
|
|
|
|
|
|
field properties reference?