Problem with currency symbol

hey guys i keep getting a diamond with a question mark in it(�) every time I try and print out a value from my database. I thought it was something to do with the pound symbol so tried to change it for its code but thats giving me the same symbol(�).

$sal = str_replace(“£”, “£”, $row[5] );
echo “<b>Salary : </b>”.$sal.“<br />”;

Anyway got any ideas?

bump bump

Can you pop up a SHOW CREATE TABLE [I]product[/I] here please - where product is the name of your table.

hi anthony, i just added this to my header

<meta http-equiv=“Content-Type” content=“text/html; charset=utf-8”>

didn’t have one before. in the above post the forum converted my code to the pound symbol. the above char set doesnt work what should i be using, if that is my problem?

thanks,

Darren.

What character encoding are you using Darren? Also, the HTML entity for £ should be & pound ; with no spaces.

is there char set my problem lol

did u mean get the table info? :slight_smile:

CREATE TABLE `jobs` (

id int(11) NOT NULL AUTO_INCREMENT,
title varchar(100) NOT NULL,
desc varchar(1500) NOT NULL,
location varchar(40) NOT NULL,
type varchar(40) NOT NULL,
sal varchar(30) NOT NULL,
date varchar(10) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=486 DEFAULT CHARSET=latin1

Hey Anthony, thanks for bearing with me on this.

I’m not sure what your asking me to do.