[dba-SQLServer]Field Sizes

John Colby jcolby at colbyconsulting.com
Mon Oct 6 12:18:08 CDT 2003


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

Which begs the question, why use varchar?  Faster than Nvarchar?


John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Mike and
Doris Manning
Sent: Monday, October 06, 2003 1:16 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Field Sizes


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

_______________________________________________
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