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?
+3
Monty
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.
+5
Monty
source
to share