phpMyAdmin:日期字段显示为BLOB [英] phpMyAdmin: Date Fields Display as BLOB

问题描述

我正在运行phpMyAdmin版本4.4.4.浏览表时，所有DATETIME和DATE字段都显示为 [BLOB 19] .我单击了表列表上方的+选项，选择了显示BLOB内容"，然后单击GO，但是，所有日期字段仍显示为[BLOB 19].

I am running phpMyAdmin version 4.4.4. When browsing a table, all of the DATETIME and DATE fields display as [BLOB 19]. I clicked on +Options above the table list, selected "Show BLOB contents" and clicked GO, but, all date fields still display as [BLOB 19].

我已经在三种不同的Mac浏览器(Safari，Chrome和Firefox)上进行了尝试，但是它们都不会显示实际日期，仅显示[BLOB 19].

I've tried this on three different Mac browsers -- Safari, Chrome and Firefox -- but none of them will display the actual date, just [BLOB 19].

如何使PMA显示实际日期而不是BLOB?

How do I make PMA show the actual date instead of BLOB?

推荐答案

此后，我找到了解决此问题的方法. phpMyAdmin没有使用mysqli扩展名.将mysqli扩展名添加到PHP后，所有日期字段开始显示日期而不是BLOB.

I have since found the solution to this problem. phpMyAdmin was not using the mysqli extension. Once I added the mysqli extension to PHP, all of the date fields started displaying the date instead of BLOB.

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