[SQL] Field Size

[Ganesan Kanavathy]

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