Menu
▾
▴
#2793 (ok 3.1.0-rc1) Query involving a function shown as binary
If you do a query with the MONTHNAME function, the result shows as an 8-bit binary column in phpMyAdmin.
SELECT MONTHNAME( NOW( ) ) AS month_name
[ phpMyAdmin result: ]
month_name
[BINARY - 8B]
However the mysql command line interface shows the name as expected:
mysql> SELECT MONTHNAME( NOW( ) ) AS month_name ;
+------------+
| month_name |
+------------+
| November |
+------------+
1 row in set (0.00 sec)
Discussion
In Options, choose Show Binary.
Now this checkbox is selected by default.