#1146 (ok 4.5) Show original size of truncated columns

[jidanni]

Say there is a giant item somewhere in our database. One can only see
the size of each table, but looking inside a table, one cannot
configure to see sizes, at most one can only configure to see the
whole item, but not just its size.

[Marc Delisle]

This is a bug? Please clarify and move to feature requests if necessary.

[jidanni]

I don't have a button to move this to a feature request.

Anyway, just like one can see size in bytes of tables, one should be able to configure to see sizes in bytes of structures smaller than tables.

[Marc Delisle]

The only column type I can think of, where this would be useful, is BLOBs and phpMyAdmin does display their size.

Moved to feature requests.

[Michal Čihař]

You mean size of each field when browsing the table? Or something different?

[jidanni]

I see the size appended to the BLOBs, and I am thankful for that.

What I encountered is

"a:5:{s:13:"administrator";a:2:{s:4:"name";s:23:"Ad..."

those three dots don't tell me if the part not shown in 10, 100,
or 100000 characters long.

Checking the Structure, we learn it is a varchar(64).
So we calm down that it can't be too long after all.
OK, I suppose the user can learn to go check the structure.

By the way, we also note type "longtext"... I suppose if those get too
long, you will show their sizes too.

[Marc Delisle]

Implemented by showing the original size when hovering over the truncated data:
https://github.com/phpmyadmin/phpmyadmin/commit/bb7a254ce4b89851bcc1e2ec030a06bb10f76724