phpMyAdmin以十六进制显示varbinary列，尽管“以十六进制显示"未选中 [英] phpMyAdmin displaying varbinary columns in Hex allthough "show in Hex" is unchecked

问题描述

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.

这篇关于phpMyAdmin以十六进制显示varbinary列，尽管“以十六进制显示"未选中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！