Re: problem displaying euro character

[Alexander Barkov]

Try the following queries in phpMyAdmin:

show variables like 'character_set%';
select hex('€');

You should have:
1. Either character_set_client being equal to latin1
with HEX('€') equal to 80.

2. Or, character_set_client equal to utf8,
and HEX('€') equal to E282AC.

If you have other combinations, your phpAdmin is misconfigured.

Also try this in phpAdmin:

INSERT INTO t1 (c1) VALUES ('€');
SELECT HEX(c1) FROM t1;

you should get E282AC.

If you do get the same result, then your phpAdmin is
configured well and you need to configure your website
software.

Try to display results of this query:

show variables like 'character_set%'

And check what your browser thinks about the site
character set, e.g. "View -> Character Encoding" in Mozilla.
It should match to character_set_results.