Link to home
Start Free TrialLog in
Avatar of betch
betch

asked on

Can't display currency symbols in SQL Query reslts

Hello all, I'm having trouble displaying currency symbols in my MySQL querys when I display them in a table.

I've tried varying combinations of Type and Collation but to no avail.

Is there a simple fix or do I need to add the symbol via php on my web page?

Thanks in advance for your help.
Avatar of Shahzad Fateh Ali
Shahzad Fateh Ali
Flag of Pakistan image

Hi,
Use html codes to store currency symbols.

Avatar of betch
betch

ASKER

Just to confirm in the Price Field of my database I should type, for example:

&pound 9.99  to display £ 9.99

Thanks for the speed of your response.

ASKER CERTIFIED SOLUTION
Avatar of Shahzad Fateh Ali
Shahzad Fateh Ali
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of betch

ASKER

Nice one shahzadfatehali.

The first method works great.

Thanks again Betch
Avatar of betch

ASKER

Thanks a lot for your help.

Betch