After additional testing here's the scoop; IE 6 -----no problem IE 5.5 ---character codes appear in DB IE 5.0 ---character codes appear in DB NS 4.7--no problem
As this is on CF5 the ReplaceList() / CHAR() approach won't work 'cause CHAR() maxes out at 255. ----- Original Message ----- From: "David K" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:25 AM Subject: Unknown character codes appearing in DB > A small utility on our intranet contains a simple form with a single textarea sending to an Access DB. Users typically copy and paste text from MS Word documents into this textarea. From time to time the following character codes show up in the database. > > ’ > “ > … > > What are these and how can we prevent this from occurring? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4