Special characters & doctypes

[Zaggs]

Hi Guys,

I have the following characters stored in a db;

$
£
€
$
¥

However, when I pull them from the database and display them on a page, I get a weird character show in place of the €, $ and ¥. However, this works fine on another server.

I originally thought this could be a problem with the doctype. I am using utf-8, but still get the same problem.

Any ideas?

[AnthonySterling]

How are you determining that they work fine on one server, but not the next? Are you using the same php application, desktop application...

There a few things this could be, but lets narrow down the options huh?

Have you tried htmlspecialchars()?

[Zaggs]

How are you determining that they work fine on one server, but not the next? Are you using the same php application, desktop application...

There a few things this could be, but lets narrow down the options huh?

I am using exactly the same php application, MySQL database and structure. The browser I am viewing with is also the same.

Weird huh?

[AnthonySterling]

As this works fine on one server, and not the other whilst everything else is the same - logic dictates the server is the issue.

Have you compared the headers sent by the servers? I'd bet a lemon-top ice cream that they are different.

The LiveHTTPHeaders extension with Firebox is usually my preferred method.

[Zaggs]

As this works fine on one server, and not the other whilst everything else is the same - logic dictates the server is the issue.

Have you compared the headers sent by the servers? I'd bet a lemon-top ice cream that they are different.

The LiveHTTPHeaders extension with Firebox is usually my preferred method.

I will check, thanks

[danNL]

You can check the headers that the web server is sending by going to View > Character Encoding in FireFox. For example, this site is using ISO-8859-1.

The problem is that the page char encoding and the server's header's can be different. And the server will "win".

This PHP header should take care of it
header( "Content-Type: text/html; charset=utf-8" );