By Default phpMyAdmin column character limit is 50. If you are browsing data where the column’s data length is above 50 characters then you wouldn’t able to see the full data in that column by default. Well there is a simple solution to the problem which can be achieved by changing the character limit in settings of phpMyAdmin.
How to change column character limit in phpMyAdmin?
First of all make sure you are in phpMyAdmin after that you can confirm you haven’t selected any database and you are inside the main server page.
- Make sure you are in the main server page by clicking localhost or whatever your server name is.
- Click on Settings
- Now move to Main Panel Page
- Select tab Browse Mode
- Change Limit column Characters from 50 to your desired number.
| Type: | integer |
|---|---|
| Default value: | 50 |
Maximum number of characters shown in any non-numeric field on browse view. Can be turned off by a toggle button on the browse page.
Limit column characters
Maximum number of characters shown in any non-numeric column on browse view.