Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

mysql fields with gibberish, need cleaning

1:41 am on Aug 20, 2008 (gmt 0)

New User

joined:May 24, 2006
votes: 0

hello, I inherited a project that has a mysql database that has large description fields that, due to an unfortunate prior import, has a bunch of gibberish chars in it.

i have been tasked to "clean up" the data, and tried a few fixes that i found on the net on the db side...none worked. so now i am going to write a "scrubber" in PHP or REGEX that parses the text and eliminates bad chars.

does anyone know of a script or snippet that performs this task?

- mark

3:50 am on Aug 20, 2008 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 7, 2004
votes: 0

I don't know, but changing the table's collation wouldn't fix the screwed up chars back to normal?