Strange Characters In Mysql

[swetha]

Hellomy database got filled with strange characters like this ’ … – “ †‘ my database collections are "utf8_unicode_ci".how can i remove these characters?Thanks in advance. Swetha

[justsomeguy]

You could probably use one of the string replace functions for whichever database you're using. e.g., MySQL has this:http://dev.mysql.com/doc/refman/5.0/en/str...unction_replace

[ProblemHelpPlease]

I had a similar issue when populating a database from an external feed that I had no control over but should have had the correct UTF8. If you are doing a similar thing then you could adjust the data as it is entered into the database

mysql_query("UPDATE tablename SET NAME = REPLACE(NAME,'–','') WHERE NAME LIKE '%–%'");

[swetha]

Thanks for ur help.i removed the characters,but some 'square boxes' are there.how to remove that boxes?Once again thanks for ur help.

I had a similar issue when populating a database from an external feed that I had no control over but should have had the correct UTF8. If you are doing a similar thing then you could adjust the data as it is entered into the database

mysql_query("UPDATE tablename SET NAME = REPLACE(NAME,'–','') WHERE NAME LIKE '%–%'");