Re: Help getting rid of Squares in DB
>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. > I believe both of those work by using Replace to find and replace the problematic character codes with a character or characters that'll display normally. A Google search for either name should bring those tools to light. I too have a database with text content containing those pesky squares (Oracle, not MySQL). I've tried to clean them up using similar replace statements, but no luck: once those characters are saved to the database, then seem to be untouchable by those techniques. But like I said, I'm using Oracle, and the data fields in question are CLOB data type fields, so maybe it'll be different with MySQL. --Brian ~| 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:280286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help getting rid of Squares in DB
Just run a query on each table that has the boxes and then do a loop and do a regex for the smartquotes and if it finds one have it replaced with a reg quote and do an update. Im sure one of the regex ninjas on here can do a quicky regex for it >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: > >> ~| ColdFusion 8 beta â Build next generation applications today. Free beta download 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:280285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help getting rid of Squares in DB
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
Re: Help getting rid of Squares in DB
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
Re: Help getting rid of Squares in DB
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
Help getting rid of Squares in DB
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
