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在localhost上执行此操作.

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屋！