Clever Geek Handbook

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


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


source






More articles:


All Articles