homepage Welcome to WebmasterWorld Guest from 54.225.1.70
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
mysql fields with gibberish, need cleaning
menriquez




msg:3726750
 1:41 am on Aug 20, 2008 (gmt 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

 

Jakotsu




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

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved