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.