Make the table listing show entire fields
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Underwater World
--
Chapters
00:00 Make The Table Listing Show Entire Fields
00:20 Accepted Answer Score 55
00:59 Answer 2 Score 21
01:12 Answer 3 Score 4
01:43 Answer 4 Score 0
02:12 Thank you
--
Full question
https://superuser.com/questions/308890/m...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#mysql #phpmyadmin
#avk47
ACCEPTED ANSWER
Score 55
Older versions of phpMyAdmin (when the question was asked)
Once you have the query results on the page there are a couple of options. In the left-most header column you should see a link something like <-- T --> If you mouse over that you will see that it toggles "full texts".
You can also click on "Print View (with full texts)" at the bottom of the results when you are viewing the partial texts. This option disappears (and is actually the default for Print View) once you have clicked the link mentioned above.
Current Versions
Click on +Options and you'll find a "Full Texts" radio button.
ANSWER 2
Score 21
Click on + Options
Select Full texts and click Go
Example image:
ANSWER 3
Score 4
There is another permanent solution if you could able to access the phpmyadmin configuration file config.inc.php. The solution is to change LimitChars property from its default value 50 to any desired value.
In ubuntu 16.04 the configuration file may be found at /etc/phpmyadmin/config.inc.php and I edited it like the following:
...
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
//Add the following line
$cfg['LimitChars'] = 128;
...
ANSWER 4
Score 0
phpMyadmin is limiting the number of characters outputted. As mentioned by SaidbakR you can change it permanently but you do not need to go into configuration file. At least this is the case in version 4.9 that I am using.
Just go to Settings > Main panel > Browse mode and change the value of "Limit column characters" to a desired number. I put 1000 for example.
