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?

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members