[SQL] Field Size

Can anyone tell me, what harm would setting a field size to 1000 characters do to the size?   By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only?   Regards, Ganesan  

Re: [SQL] Field Size

Can anyone tell me, what harm would setting a field size to 1000 characters do to the size?   By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only?   Regards, Ganesan