I've inherited a MySQL db (4MB on disk) that's riddled with
inconsistent storage of character entities from being pasted from
Word. At very least I hope to convert all quotes "‘" - "”"
to HTML's """ and "'".
I imagine I'll run a big query, save the id's needing edit in a file
than have a script hit all those, pulling text/varchar fields, using
strtr() to make changes and updating. I suppose I could have the
script just do the 1st 10 in the file, remove those from the file,
then I'd recall the script. I imagine this might take 10/20 minutes.
Am I missing some internal MySQL feature that would do this? Hmm,
what about running strtr() on a mysqldump-ed file? Any advice/links
appreciated. Please CC me.
Thanks a lot!
[EMAIL PROTECTED] ** http://mrclay.org
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php