On SQL Server NVARCHAR can be up to 4000. Just do a Len() in the data to see if it is as long as you think it is.
Adrian -----Original Message----- From: [EMAIL PROTECTED] Sent: 17 March 2008 18:01 To: CF-Talk Subject: RE: binary data would be truncated Nvarchar only allows 255 characters. NText is the field you want if its paragraphs you are storing. Rick Eidson The KChost Radio Network http://www.kchost.net/ Eidson Empire http://www.eidsonsempire.com/ -----Original Message----- From: John P Sent: March 17, 2008 1:47 PM To: CF-Talk Subject: binary data would be truncated I'm having a problem with a form which is giving the following error on insert of text fields which contain a paragraph or two of data. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated. This error would seem to me to be created by a MSSQL datatype which is not large enough to hold the inserted data. I was using nvarchar and have since switched to ntext which seems to have fixed the problem. I'm a bit confused as to why nvarchar was causing the error as the data being submitted was well under the nvarchar limit, 2 or 3 paragraphs. I am trimming all of the data I am inserting. Any thoughts? Thanks, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
