LinuxQuestions.org - Help with phpMyAdmin configuration (charset issues)

Hello.

I'm using UTF-8 in my MySQL database and all foreign characters display well on my utf-8 web page after queries to MySQL without any form on conversion in my PHP code - such as utf8_encode().

But phpMyAdmin displays everything garbled. I can't enter anything directly from it either, it will simply enter everything in latin-1 in my MySQL.

I configured my phpMyAdmin like so:

Code:

$cfg['Lang'] = 'en-utf-8';

$cfg['DefaultCharset'] = 'utf-8';

$cfg['AllowAnywhereRecoding'] = true;

$cfg['AvailableCharsets'] = array('utf-8');

As you can see, I even killed all other available charsets just to be sure utf-8 is the only one I want.

Some other solutions I found on the web included modifications in my.cnf or php.ini but I don't see why this would work, since I do have successful queries out of a simple php + mysql interface I built myself. There must be some other option in phpMyAdmin that I'm missing here.

Any help appreciated.

Thanks.