Re: problem displaying euro character
Posted by: Alexander Barkov
Date: June 08, 2006 04:57AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: problem displaying euro character
2253
June 08, 2006 04:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.