There are custom tags cleanMSText or demoronize that may aid you in automating their removal. I have found cleanMSText works better than demoronize, but I cant seem to find it right now.
On 6/6/07, Tom King <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
