£ changing to ? in a diamond

[dmccabe]

Hopefully this makes sense, so here goes, I have the £ symbol on some of my pages, but for some reason it is being changed in to a ? within a diamond.

 

anyone know why this is?

[Mattyspatty]

its something to do with the characterset of your browser. i think you can resolve it by using the HTML code for it. try £ or &pound

[thebadbad]

Character set set wrong somewhere. It should be the same for your (X)HTML documents, your database collations and your database connection.

 

UTF-8 example:

 

XHTML (inside head tags):

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

 

Database connection (after connecting to database in your PHP script):

<?php
//call to mysql_connect() saved in $connection, and call to mysql_select_db() goes here
mysql_query("SET NAMES 'utf8'", $connection);
mysql_query('SET CHARACTER SET utf8', $connection);
?>

[effigy]

The pound sign itself is not a valid UTF-8 encoding. See this for more info.

[thebadbad]

Then how come it works on my site? It's using UTF-8 all the way (utf8_unicode_ci for database, tables and fields).

 

Edit: Doesn't this imply that it does? I could be wrong though.

[effigy]

If you see the pound sign and you're using UTF-8, then it is properly encoded as "£". "£" alone will result in the black diamond question mark.

[dmccabe]

I will check it out again tomorrow, am at home now so cant look.

 

Thanks so far though!