phpMyAdmin - 将 BLOB 字段显示为文本? [英] phpMyAdmin - Show BLOB fields as text?

问题描述

我想知道为什么在 phpMyAdmin 中我看到这样的内容:

I was wondering why in phpMyAdmin I see something like this:

**Edit    Inline Edit     Copy   Delete [BLOB - 7B] [BLOB - 32B]    [BLOB - 13B]    [BLOB - 16B]**

为什么我看不到实际文本?当我单击 [BLOB-/nx/] 时，系统会提示我下载 .BIN 文件.

Why can't I see the actual text? When I click [BLOB-/nx/], I just get prompted to download a .BIN file.

我尝试添加:

$cfg['ShowBlob']              = true;

到phpMYAdmin/config.inc.php，但是没有用.我还尝试添加到 URL &display_blob=true.

To phpMYAdmin/config.inc.php, but it didn't work. I have also tried adding to the URL &display_blob=true.

顺便说一下，我正在尝试使用 XAMPP 在本地主机上执行此操作.

I am trying to do this on localhost with XAMPP by the way.

如果需要，我的 phpMyAdmin 版本是 3.4.5.

My version of phpMyAdmin is 3.4.5, if it's needed.

推荐答案

phpMyAdmin 在每个结果集的顶部都有一个+option"链接.单击它，您将看到显示 blob 内容的选项.

phpMyAdmin has an "+option" link on top of each result set. Click it, and you will see the option to display blob contents.

我应该补充一点:一些phpMyAdmin版本有一个错误，即+option"链接在第一次加载结果时不显示，您需要单击[刷新]使其出现.

I should add: some phpMyAdmin versions have a bug where the "+option" link does not show up on the first load of the results, you need to click [ Refresh ] to make it appear.

这篇关于phpMyAdmin - 将 BLOB 字段显示为文本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！