how to get rid of special character Â?

[chaohua wang]

Hi Folks

When i updated a product name  using West®  East®food  in Catalog
-->Content,
in product_name field of  Product table,  the value is like this   West®
East® food.
This value is presented in PDF report file,
I want to remove  Â.
I read this article. it says I need to  set "UTF-8"  for mySQL.

SET NAMES 'utf8';

http://www.byteflex.co.uk/en/fun_with_utf8_php_and_mysql.html


but updateProdcut is using minilan in ProductServices.xml.

could you tell me how to fix this issue?
Thanks,

Chwang