[dba-SQLServer]Field Sizes

Mike and Doris Manning mikedorism at ntelos.net
Mon Oct 6 12:15:32 CDT 2003


It does if you use varchar (pads the rest with spaces) but it does not if
you use nvarchar.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Monday, October 06, 2003 9: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
www.colbyconsulting.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list