#1673 (ok 4.5) Browse: improve display of right-aligned data

[Marc Delisle]

See http://stackoverflow.com/questions/30154417/how-to-center-data-in-table-cells-in-phpmyadmin

Maybe add in Browse > Options a checkbox "Center numeric data" ?

[Rakesh Kumar]

Hi Marc,

I think the problem is that all column types are not similar aligned, for ex- integer types (arrivalstime_id) are right aligned while varchar, date (weekday) are left aligned. I suggest if all columns have same alignment, left or right or center, then readability should not be a problem.
What do you think ? Should I make all the alignments same ?

[Marc Delisle]

Hi Rakesh,
well I'm not sure. Left-aligning character columns seem correct to me. In the screenshot shown on the above link, maybe it's more a missing padding problem?

Also, I believe that by default, it's ok to right-align numbers. It's not visible in the screenshot but if you have 1-digit numbers and 3-digit numbers, centering them would not make sense.

[Madhura Jayaratne]

I also think it's missing padding and agree with the current alignments. I also don't think we should provide a configuration.

[Isaac Bennetch]

I think the way we display data is rather aligned with industry standards; look at the alignment done by a spreadsheet program and you'll see some data types are left-aligned and others are right-aligned. So without adding another radio button in the Options area and/or configuration directive, I think we've selected the best available solution.

I believe some of the other display options (such as "Show BLOB contents") are strictly stored in the session; would it be reasonable to provide a radio button for "left", "right", and "smart" alignment here?

[Marc Delisle]

Isaac,
Now I think it's only a padding problem.

[Marc Delisle]

Fix: https://github.com/phpmyadmin/phpmyadmin/pull/1692