Thanks for your help guys.
John >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 > >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/ > > >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:301432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4