phpMyAdmin以十六进制显示varbinary列,尽管“以十六进制显示"未选中

phpMyAdmin以十六进制显示varbinary列,尽管“以十六进制显示

问题描述:

phpMayAdmin 4(无框架版本)

phpMayAdmin 4 (frameless Version)

我想知道其他人是否遇到了这个问题:

I'm wondering whether someone else has encountered this problem:

在"varbinary"类型的所有列上,phpMyAdmin会将显示的值从查询转换为十六进制.在选项标签上,有一个选中标记将二进制内容显示为十六进制",并且未选中.

on all columns of type "varbinary", phpMyAdmin converts shown values from a query to Hex. On the options tab there's a checkmark "Show binary contents as HEX", and this is un-checked.

由于旧文档设置了一些配置字段,但没有效果.

There are some config fields which are set due to the old documentation, but with no effect.

我如何说服phpMyAdmin做我想做的事情,以及我告诉他做的事情:显示来自数据库的纯未转换值?

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

您是否已检查错误报告?

Have you checked this bug report?

我引用答案.

似乎此补丁会引起另一个问题.

Seems that this patch cause another problem.

在里程碑4.0.1,php5.3上,当将列设置为整理utf8-bin时, 数据的值始终显示为十六进制,无论 display_binary_as_hex是.

On milestone 4.0.1, php5.3, when a column is set to collate utf8-bin, data is always displayed as hexadecimal, whatever the value of display_binary_as_hex is.

如果使用php,请查看library/DisplayResults.class.php,第5941行 版本是< 5.4,则每次都会调用bin2hex.

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

之所以进行检查是因为5.3中不存在ENT_SUBSTITUTE, 但我认为没有此常数的呼叫比无条件呼叫更好 调用bin2hex.

The check is done because of no existence of ENT_SUBSTITUTE in 5.3, but i think a call without this constant is better than inconditionnel call to bin2hex.