Phpmyadmin gibberish at main table overview (but ok when click on edit)

Question

phpmyadmin screenshot

My phpmyadmin is funny

The last couple of days, the overview of the table columns is total "encoded" gibberish

But when I click on edit on any of them, the real content shows just fine Everything is set to be UTF-8 by the way

The database works perfectly otherwise

Don't know what's happening. Do you?

What is the character set in your database and what is there in your phpmyadmin? — Rajarshi Goswami, Jun 20 '14 at 12:32
Connection Charset is UTF-8 bin. Charset for the database and all tables in is UTF-8 bin. — mowgli, Jun 20 '14 at 13:14
Can you please mention which phpMyAdmin version it is and are those fields of type binary or blob? — Chirayu Chiripal, Jun 21 '14 at 13:04
The fields are int and varchar. Phpmyadmin 3.3.0 (I cant't upgrade) — mowgli, Jun 21 '14 at 22:11

Chirayu Chiripal · Answer 1 · 2014-06-21T22:24:29.593

3

With no version mentioned it's difficult to answer but it seems like those fields are of BINARY or BLOB data types or maybe because of utf8_bin they are treated as binary and are displayed in hexadecimal (0-9,A-F) form. Try this:

Click on '+options' link (just above that display table)
Uncheck 'Show binary contents as HEX' option.
Click 'Go'.

Edit 1 (In danish it should be something like this):

'+options' is '+indstillinger'
'Show binary contents as HEX' is 'Vis binært indhold som HEX'
'Go' is 'Udfør'

edited Jun 21 '14 at 22:24

answered Jun 21 '14 at 13:17

Chirayu Chiripal

610
6
15

The fields are int and varchar. Phpmyadmin 3.3.0. Strange, they only look scewed at front table view, not in edit page – mowgli Jun 21 '14 at 22:12
Can't see any options link – mowgli Jun 21 '14 at 22:20
@mowgli, see translations in updated answer or try it by setting english language. – Chirayu Chiripal Jun 21 '14 at 22:25
I have no binary/hex options – mowgli Jun 26 '14 at 13:45

score 1 · Accepted Answer · answered Jun 26 '14 at 13:50

1

Check if $cfg['DisplayBinaryAsHex'] = true; in config.inc.php and if it is true set it to false. That might help.

answered Jun 26 '14 at 13:50

Marko Vasic

690
9
27

Phpmyadmin gibberish at main table overview (but ok when click on edit)

2 Answers2