how to remove � sign in php while displaying content from mysql table

Question

The web page shows the content as below

Golden Temple�is a Sikh�Gurdwara�located in the city of�Amritsar,�Punjab,�India. It was built by�Guru Arjan, in the 16th Century.

but the actual content is as below

Golden Temple is a Sikh Gurdwara located in the city of Amritsar,Punjab,India. It was built by Guru Arjan, in the 16th Century.

please help me

Encoding FTW......Hint: [This](http://kunststube.net/encoding/) should help you — asprin, May 15 '14 at 06:23
You're going to have to provide more details on the encoding used in your application and on the database. — rink.attendant.6, May 15 '14 at 06:24
Don't try to *remove* them. You need to find, why they are generated and fix it right there at the source. — Peon, May 15 '14 at 06:31
i'm using utf-8 charset in and Collation of database is latin1_swedidh_ci — Rahul, May 15 '14 at 06:34
Don't forget to let mysql know you're communicating in UTF-8: `$connection->set_charset("UTF8");` — Michel, May 15 '14 at 06:55

score 1 · Answer 1 · answered May 15 '14 at 06:26

1

Try with

$result = preg_replace('/[^\x00-\x7F]+/', '', $dbstring); // remove all non-ASCII (so called special) characters from your string:

or

$result=utf8_encode($dbstring);  // encodes an ISO-8859-1 string to UTF-8

answered May 15 '14 at 06:26

Jenz

but i want to use multiple languages like english, urdu, arebic, hindi etc . this is not working with other languages – Rahul May 15 '14 at 06:57

1 Answers1