[plug] Question marks in table after mysql migration

[Shannon Carver]

Ech! Can't be a fun situation to be in.

How large is the data?

You could do it via SQL:
UPDATE table_name SET
field_name=replace(field_name,'search_text','replace_text');
So:
UPDATE table_name SET field_name=replace(field_name,'?',' ');

Gotta be a better way than that though!


> -----Original Message-----
> From: plug-bounces at plug.org.au [mailto:plug-bounces at plug.org.au] On Behalf
> Of Shayne O'Neill
> Sent: Tuesday, 12 September 2006 3:17 PM
> To: plug at plug.org.au
> Subject: [plug] Question marks in table after mysql migration
> 
> 
> Hey,
> 
> I've got a slightly bamboozling problem!
> 
> I've transferred a large table from an old webhost to an internal
> webhost, and in the process have had a sprinkling of random question
> marks thru the data. Now, Im thinking the question marks are some sort
> of unicode wierdness, but yeah. Problem is, the table is now in active
> use (before we noticed this), so I cant try again with a more sensible
> eye on codepages.
> 
> Any suggestions on an easy way to weed these little buggers out? The
> table has no valid reason to have any question marks in it, so I figure
> I can just replace the ?'s with spaces, but for the life of me I cant
> work out how to do it :(
> 
> Any suggestions?
> 
> Cheers,
> Shayne
> Best flights IT dept.
> _______________________________________________
> PLUG discussion list: plug at plug.org.au
> http://www.plug.org.au/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au