Weird display problem

PHP
1

Hi folks

I hope someone can help with this issue I am having, I have created a simple news system for a site I am working on. Basically it takes the value in a text box and saves it to a mysql database. I also have a page where the news is displayed in a <p> tag.

It all seems to work fine except when you enter a £ symbol. It saves the symbol ok to the database and when read back into a textbox it displays as a £ symbol, BUT the issue is when reading the data to display in a <p> tag it displays as a little black diamond with a ? symbol in it.

I am pretty new to php and haven’t managed to work out why this is happening yet. I have attached a couple of shots to help demonstrate what I am on about. 1st is the text boxes

and second is the <p> tag version.

I hope someone is able to help with this it is doing my head in :confused:.

Thanks in advance.

Mike

2

Inconsistent character sets between the web server’s content-type header, the PHP code (whose string functions are not multibyte encoding safe), the database connection and the database table.

You should probably make sure they are all set to utf8 and avoid using any standard string manipulation functions in PHP.

3

Thanks Dan, setting everything to utf-8 solved it.:slight_smile:

Much appreciated.

Mike