David, Check out Taz's tag.
I use it in a couple of places where users copy and paste text in from Word for content on the site. It sorts out most, if not all, of those weird MS characters. Stephen ----- Original Message ----- From: "David K" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 7:25 PM Subject: Re: Unknown character codes appearing in DB > 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
