phpmyadmin显示mysql的utf8_bin调用列的数字或blob吗? [英] phpmyadmin shows numbers or blob for mysql's utf8_bin callation columns?

问题描述

我有一个带有varchar列的表.它的排序规则设置为utf8_bin.我使用此表和列的软件运行良好.但是，当我查看phpmyadmin中的内容时，我只看到一些十六进制值或[Blob xB].我可以使phpmyadmin正确显示内容吗?

I have a table with a varchar column. Its collation is set to utf8_bin. My software using this table and column works perfectly. But when I look at the content in phpmyadmin, I only see some hex values or [Blob xB]. Can I make phpmyadmin show the content correctly?

此外，当我将排序规则设置为utf8_general_ci或utf8_unicode_ci时，phpmyadmin会正确显示内容.

Besides, when I set the collation to utf8_general_ci or utf8_unicode_ci, the phpmyadmin shows the content correctly.

Thx 马克

[edit]嗯，我发现，phpmyadmin中每个表上方都有一个小的"+ Options"链接.它打开了几个选项，包括显示BLOB内容"(启用时使[blob]变为可读文本)和禁用时将十六进制代码显示为文本"的将二进制内容显示为十六进制".

[edit]Hah, I found out, there is a small "+Options" link above every table in phpmyadmin. It opens several options including "Show BLOB contents" - which makes the [blob] to readable text when enabled and "Show binary contents as HEX" which shows the hex codes as text when disabled.

不知道为什么会有两个选项，为什么有时会有[Blob]值，有时是十六进制值.

No idea why there are two options though and why sometimes there is a [Blob] and sometimes hex values.

好吧.现在我仍然在想:当我转到另一个表时，设置这些选项会丢失.我每次去那里都必须设置它们.有没有办法保存这些选项? [/edit]

Well. Now I'm still wondering: Setting these options get lost when I go to another table. I have to set them every time I go there. Is there a way to save those options? [/edit]

推荐答案

• 请勿编辑此文件，请编辑config.inc.php ！！！

因此，要按照PMA作者的正确文档进行操作，请编辑config.inc.php. 添加行: $ cfg ['DisplayBinaryAsHex'] = false;

So, to do this in line with PMA author's correct documentation, edit config.inc.php. Add the line: $cfg['DisplayBinaryAsHex'] = false;

到您的config.inc.php文件.

to your config.inc.php file.

;-)

这篇关于phpmyadmin显示mysql的utf8_bin调用列的数字或blob吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！