16, is the size of the text pointer which points to another storage location where the actual text is stored. I'm not sure why it would tell you that the data will be truncated since a text field should hold far more than 8000 characters. Perhaps it is a just-in-case message.
Are you on SQL Server 2000? If you are on 2005, the varchar(max) is much better than text. ~Brad -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:41 AM To: CF-Talk Subject: (ot) MS SQL Server 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4