[dba-SQLServer]Field Sizes

Djabarov, Robert Robert.Djabarov at usaa.com
Mon Oct 6 09:43:57 CDT 2003

It will be similar if you choose varchar(255)

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John
Sent: Monday, October 06, 2003 8:59 AM
To: SQLServer
Subject: [dba-SQLServer]Field Sizes

Access stores text and memo data using the exact amount needed (plus
pointers) , i.e. even though the text field says 255 characters if the
string is 10 characters, 10 characters are used for storage.

Does SQL Server work this way of is space "reserved" for the stated size
of the field?

John W. Colby

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list