MySQL Forums :: Character Sets, Collation, Unicode :: Character encodings issues with php, mysql, apache


Advanced Search

Character encodings issues with php, mysql, apache
Posted by: Miguel Rojas ()
Date: March 27, 2009 09:46AM

Hello, I'm having an issue here with a MySQL database and a PHP application.

The database uses utf-8 encoding, the applicaction generates a web page with utf-8 encoding, sending a utf-8 header. The page rendering is Ok. (It's in spanish, and the latin characters, i.e. : á, é, are Ok).

With phpMyAdmin however, the characters look like "ó", "á" or "é"

In the console, using an utf-8 terminal, the characters in database look ok.

When I edit a field directly in phpMyAdmin, the characters look again (in phpMyAdmin) like 'á', 'é' but in the page look like ?.

We are having problems with searches for example, in the current searches 'á' <> 'a', with is a problem in spanish.

I'm a little confused here, anyone can lend a hand with this problem?

Thanks in advance!

Options: ReplyQuote


Subject Views Written By Posted
Character encodings issues with php, mysql, apache 8202 Miguel Rojas 03/27/2009 09:46AM
Re: Character encodings issues with php, mysql, apache 3797 Rick James 03/28/2009 04:04PM
Re: Character encodings issues with php, mysql, apache 4198 Miguel Rojas 03/30/2009 10:20AM
Re: Character encodings issues with php, mysql, apache 3266 Miguel Rojas 03/30/2009 01:10PM
Re: Character encodings issues with php, mysql, apache 3340 Rick James 03/30/2009 07:46PM
Re: Character encodings issues with php, mysql, apache 3408 Miguel Rojas 03/31/2009 07:57AM
Re: Character encodings issues with php, mysql, apache 4357 Rick James 03/31/2009 07:46PM
Re: Character encodings issues with php, mysql, apache 3481 Miguel Rojas 04/01/2009 02:47PM
Re: Character encodings issues with php, mysql, apache 3344 Rick James 04/02/2009 08:36PM
Re: Character encodings issues with php, mysql, apache 3522 Miguel Rojas 04/06/2009 12:04PM
Re: Character encodings issues with php, mysql, apache 7235 Miguel Rojas 04/13/2009 05:10PM


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.