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.
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.
ASKER
Just to confirm in the Price Field of my database I should type, for example:
£ 9.99 to display £ 9.99
Thanks for the speed of your response.
£ 9.99 to display £ 9.99
Thanks for the speed of your response.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nice one shahzadfatehali.
The first method works great.
Thanks again Betch
The first method works great.
Thanks again Betch
ASKER
Thanks a lot for your help.
Betch
Betch
Use html codes to store currency symbols.