Size of database

[teknogeek9]

Is a table with a varchar field size of 1000 bigger than a table with a varchar field size of 500? Or, is the size of the table defined by the actual amount of data in the varchar field?

 

[johnherman]

It's the data that matters most. There are bits used to track the number of bytes used in a varchar, but it's negligible compared to the data itself. a

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[VBrit]

varchar means variable length characters. It stores the characters in the field and the length of the field actually used to allocate the disk space.