> If I convert an column in a table that is curently a type of > 'varchar(8000)' to a type of 'text(16)', does this truncate > the data? > > I'm using Enterprise manager, when I put the conversion in, > I note I can not change the size, so I presume that text is > always size '16' and that this references the rest of the > text however MS SQL Server handles this data type. When I do > this, I get the 'data could be truncated' message. Is this > just a proforma message, or am I possible not setting this > up properly so that there is enough space for the current > data in the field.
Text and ntext fields are always listed as that size. That's the size of the pointer to the actual storage location. I don't think you'll truncate your data in the conversion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
