Solved

Can't display currency symbols in SQL Query reslts

Posted on 2008-10-22
5
1,066 Views
Last Modified: 2013-12-13
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.
0
Comment
Question by:betch
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Shahzad Fateh Ali
ID: 22774887
Hi,
Use html codes to store currency symbols.

0
 

Author Comment

by:betch
ID: 22774931
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.

0
 
LVL 9

Accepted Solution

by:
Shahzad Fateh Ali earned 250 total points
ID: 22774947
It would be better if you use two columns, one for price (double) and other for sign (varchar).
and to display concate thm.
0
 

Author Comment

by:betch
ID: 22775060
Nice one shahzadfatehali.

The first method works great.

Thanks again Betch
0
 

Author Closing Comment

by:betch
ID: 31508672
Thanks a lot for your help.

Betch
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Introduction Many web sites contain image galleries; a common design for these galleries includes a page with a collection of thumbnail images.  You can click on each of the thumbnail images to see the larger version of the image.  This is easily i…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now