Hello,

Since very recently the euro signs that are retrieved from the database are displayed as a square. Euro signs that are typed in the php page are displayed correctly. When i look at phpmyadmin, the euro sign is correctly stored in the database.

What could have changed?

thanks!

Matt

It's not related to the db.
Looks like you don't have the correct codepage specified in your site.

Are your pages displayed in utf8, latin1 (iso8859-1) or latin15 (iso8859-15) ?
As far as I know, you need either utf8 or latin15 to display the Euro sign.

phpMyAdmin displays it right, as it uses utf8 to display it's pages.

The charset is latin1. Changed to both utf8 or latin 15 with no result. But the strange thing is:
-that everything worked before
-that € signs typed directly in the php page are displayed correctly, only those fetched from the database give a square.

What is wrong?

thanks!

Matt

What character set is the database though?

Another thing that strikes me, is that PHP is not UTF-8 compatible.
More specifically, the string functions are not.

If you try to transform, replace or do something on an utf-8 string that comes from the db, you will need to use the multibyte module from php.
http://www.php.net/manual/en/ref.mbstring.php

Originally Posted by chrishirst

What character set is the database though?

it is set to latin1_bin.
My local copy (xampp) has latin1_general_ci and works fine. I have already tried changing the specific field to latin1_general_ci but that did not help.

Thanks!

Matt