PhpMyAdmin: date fields are rendered as BLOB

I am running phpMyAdmin version 4.4.4. When viewing the table, all DATETIME and DATE fields are displayed as [BLOB 19] . I clicked + Options above the list of tables, selected "Show BLOB content" and clicked GO, but all date fields are still displayed as [BLOB 19].

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

How can I get PMA to display actual date instead of BLOB?


source to share

1 answer

I have since found a solution to this problem. phpMyAdmin did not use the mysqli extension. When I added the mysqli extension to PHP, all date fields started showing date instead of BLOB.



All Articles