Could you elaborate? As I see it, there's no way I can refer to the blocks in a SQL statement?
Ta T On 6 Jun 2007, at 00:03, Dave l wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
