[dba-SQLServer] Convert from ntext to varchar

Steven W. Erbach serbach at new.rr.com
Thu Jan 6 13:42:01 CST 2005


Doris,

Thank you very much. Any idea why a varchar or an ntext field requires a LENGTH? Inquiring minds...

Steve Erbach
Neenah, WI


> ------------Original Message------------
> From: Mike & Doris Manning <mikedorism at adelphia.net>
> To: dba-sqlserver at databaseadvisors.com
> Date: Thu, Jan-6-2005 1:27 PM
> Subject: RE: [dba-SQLServer] Convert from ntext to varchar
> 
> The answer to your bulk up question is "NO".  If you were using CHAR
> datatype it would because SQL would pad the field with enough spaces to 
> make
> 8000 characters.  With VARCHAR, that does not happen.
> 
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com





More information about the dba-SQLServer mailing list