Currency symbols don't display in database results

[menre]

Hello,

I have data in a MySQL database with currency symbols used. But when I display the results on a web page, only the '$' symbol displays with the amount correctly. I get results like the ones below.

USD: $100
EURO: ?100
Pounds: ?100
It goes on like that. Does anyone know how to fix this kind of issue please?

I will appreciate your help.

[fjober]

As I think: the dollar sign is one of the ASCII characters, you may find it on the keyboard, while the other symbols need special way to be viewed on the webpage so they need a special way to be stored in the database. Read about HTML entities.

http://www.w3schools.com/html/html_entities.asp

regards ,

Feras Jobeir

[menre]

Yes, that has actually solved the problems. Entering code like
£
€
¥
and so on to represent the data in the database is the trick to get those currency symbols.

Thank you very much.