How to set "full texts" as default for phpMyAdmin?

phpmyadmin

Solution

Here's the hacky solution (that works for me) but require changing some PMA php files. If you know what you're doing, you can try this:

- in your phpmyadmin folder locate this file: `phpmyadmin/libraries/display_tbl.lib.php`

- in this file locate function called `PMA_displayTable_checkConfigParams`

- in the beginning of this function add the line below:

    if (!isset($_REQUEST['display_text'])) $_REQUEST['display_text'] = 'F';

This would enable the "full text" by default allowing you to switch back to the "partial text" mode.

Please mind that i was testing this on a slightly different PMA version (3.5.2.2), so the function/file names might be different.

Problem

I am using phpMyAdmin v3.4.10.1deb1 to manage some MySQL-Tables on my Ubuntu-Server with fields that have the SQL-format "TEXT". When those fields are displayed, they are truncated by default. I always have to click on the Symbol "←T→" to expand the texts to their full length. But I don't want to do this click on every single query, because this means, that every query hat do be done twice. I want that "full texts" is default. But I don't find the place where to set this. Can you help?

Original source