Re: Use of large field definitions for small values
Posted by --CELKO-- on 08/03/07 14:53
>> This is a question of "what does it cost me". <<
Data integrity. If you allow a NVARCHAR(50) for a ZIP code, like a
lot of newbies do, you will get a 50 character ZIP code in Chinese one
day. The cost in storage and access time is minimal compared to
getting the wrong answers.