SC> I've inherited a MySQL db (4MB on disk) that's riddled with
SC> inconsistent storage of character entities from being pasted from
SC> Word. At very least I hope to convert all quotes "‘" - "”"
SC> to HTML's """ and "'".
For each entity you wanted to replace, you could:
update tablename set fieldwithcrap = replace(fieldwithcrap,
Keep an eye on all your escaping and what not. And do a dump before
you do all your replacing, just in case something goes awry.
If that doesn't work well, then I'd probably dump the data, run it
through a string replacing script, and load it all back in. That
wouldn't take too long either.
--> Julie Meloni
--> [EMAIL PROTECTED]
Find "Sams Teach Yourself MySQL in 24 Hours" at
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php