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? Isaac Dealey Certified Advanced ColdFusion 5 Developer new epoch www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
