you could run a query and copy in a smartquotes to sort by then update with normal quotes.
Another BIG thank you to microcrap for those. >Hi All, >I've inherited a database which has loads of squares in the middle of >text - i.e incorrectly encoded quotes, and other chars which bring >out this type of wierdness when displayed. > >They are inconsistent as to what they are, but the majority are (or >were) single quotes. > >Any tips on automating their removal (or replacement with single >quotes) in a MySQL database? They are obviously 100's to 1000's of >entries, so I'd REALLY rather avoid having to edit this manually (or >indeed open every page they're on and resave)... > >Thanks ! > >T ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
