PhpMyAdmin displaying varbinary columns in Hex allthough "show in Hex" is not set

Question

phpMayAdmin 4 (frameless version)

I am wondering if anyone else ran into this problem:

for all columns of type "varbinary", phpMyAdmin converts the displayed values ​​from the request to Hex. On the options tab there is a checkmark "Show binary contents as HEX", and this has not been verified.

There are several configuration fields that are set due to old documentation, but without effect.

How can I convince phpMyAdmin to do what I want and what I told him to: Show pure unconverted values ​​from the database?

Answer 1

Did you flag this error report?

I quote this answer.

This patch seems to be causing another problem.

In milestone 4.0.1, php5.3, when the column is set for utf8-bin mapping, the data is always displayed as hexadecimal, regardless of the value of display_binary_as_hex is.

Looking at the /DisplayResults.class.php libraries, line 5941, if php version <5.4, then bin2hex is called every time.

The check is done due to the lack of ENT_SUBSTITUTE in 5.3, but I think that calling without this constant is better than inconditionnel call bin2hex.

Answer 2

I have not tried it yet, but it may help: change this line in config.inc.php from

$cfg['DisplayBinaryAsHex'] = true; 

to

 $cfg['DisplayBinaryAsHex'] = false;