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 '
Where did you get the content from? It could be a special character in Word, a funny line break etc. The best thing to do is run the content through a php script which takes out characters outside of a certain entity range. To remove it from MySQL, create a PHP script to loop through the table, filter out those characters and update the table.