Machine Code Bad Characters - Little  's all over the site

[milobloom]

It wouldnt bother me so much,

Howewver all the Product feeds are telling me I have formatting errors.

I think its all this machine code that somehow got caught up in my files.

Alot of characters like this - Â '\0xa0' '\0x9d'

Is there anyway to get rid of them all. Optimize my database and clean them up? A program perhaps??


Here is my thought... And its probably a risky one... (Of course I would back up first...

Open the entire database in notepad? ok i guess a bigger text editor.
The search and replace the terms.

Problem is I dont even know all the terms to look for.

A search on terms like  '\0xa0' '\0x9d' just brings me to sites with the same problem....

[milobloom]

Would it be a bad idea?

[Merlinpa1969]

Yes that will work,
just export the products description and the categories description,

do a quick search and replace, then re-upload, remembering to use the drop table if exsists statement first