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