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/

1 comment:

  1. 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.