Mysql Special Character Solution

[rajivadhy]

Hi,

WE have uploaded content into the site and in place(frontend) we get the character �


How do we
1- find and remove this in mysql (does not accept special characters)
2- Avoid this in future
seeing main fault is with '

[rocknbil]

MySQL doesn't do this inherently, it's in your programming. I'm guessing WordPress?