Saturday, December 18, 2010

phpMyAdmin collated db in utf8_bin shows hex data instead of UTF8 text

Expanding options and setting 'show binary contents' then pressing 'Go' fixes it.

and $cfg['DisplayBinaryAsHex'] = false;

 in /usr/share/webapps/phpMyAdmin/config.inc.php

Posted by at

1 comment:

  1. sh4dowMarch 2, 2012 at 3:03 PM

    One issue people may have when changing the config file (I know I had it just now) is: damn cookies!

    If the settings don't seem to take effect even after restarting the server, try deleting the cookies for localhost. Worked for me.

    ReplyDelete

Subscribe to: Post Comments (Atom)