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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
