> I've got an online form that updates a MSSQL 2000 record. When I send > more than 3500 characters, I get the error:
nvarchar == 2bytes per char. 4k nvarchar chars = 2k chars. so yes you've exceeded the column size. don't use "N" datatypes unless you need to, --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists