Wilmington Pizza Insulting the stretch of pavement and stripmalls you call home

28Mar/120

New hosting

Posted by pete

I had some initial issues transferring the main database over. Somehow, 113 instances of this character: Â showed up, interspersed in many posts. Then I looked closer and they were in the original database too, but I had no idea how these jerks got in there. I'm listing the mysql lines I used to correct the issue below, since it's both of no use to you and it might come in handy for me later.

update TABLE_NAME set COLUMN_NAME = replace(COLUMN_NAME,'Â',' ');

If there are any other problems, besides my vulgarity, please let me know.