Thanks Jochem, I took a closer look at the documentation for SQL Server 2000 and it gives 2^30 -1 (1,xxx,xxx,xxx) as the maximum length for an ntext field...
So ... considering that the entire file performing the insertion of data into this table is no more than 5k I'm suspect that there's something else going on here... I can't for the life of me figure out what tho... All of the column lengths defined in the original db are the same as defined in the new db ( maybe I should double them since I'm using nvarchar instead of varchar now ) ... but the only other nvarchar fields in the table have character lengths of 255 and 7 and are receiving data that is 20-25 and 0 characters respectively .. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > S. Isaac Dealey wrote: >> I have a db where I had been using a text field and I'm >> converting it to an >> ntext field so that the db can potentially support >> unicode at a much later >> date. >> >> The problem I'm having is this: I'm not just opening the >> db and changing the >> field to ntext, I created a new db and created the new >> table with ntext and >> am importing the data from the original db using a query. >> On one record in >> particular, I get a right-data truncation error. Do text >> and ntext fields >> not have the same maximum length? Is the size of the data >> more limited in an >> ntext field as a result of using a larger number to >> represent each >> character? > Max lengths of fields is implementation defined, but > usually the length > in characters is for ntext is half that of text (wil > result in the same > length in bytes is a 2-byte form-of-use). > To figure out what is exactly going one, try to compare > the results of > the character_length() function (number of characters) > with the results > of the octet_length() function (number of bytes). (Those > are the > official names, your database might have named them > differently.) > Jochem > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/index.cfm?sideb > ar=lists&body=lists/cf_talk > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Structure your ColdFusion code with Fusebox. Get the > official book at http://www.fusionauthority.com/bkinfo.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
