sql table column won't show completely.

[osherdo]

Hello Guys.

 

I am having a trouble viewing a specific column content both in phpMyAdmin and console.It only shows a partial info about the contents inside that column.

 

I have attached a screenshot of this to give you a demonstration inside that link:

 

http://i59.tinypic.com/2n6ymqf.jpg

 

as you can see , the user picked hamburger ,steak and ground beef (and some more), but it seems that it stops showing it right in the middle of the word. Is there any limit for characters in this case?

 

What would be possible to figure that out please?

 

Thanks in advance..

Edited December 18, 2014 by osherdo

[osherdo]

Just figured it out. Used The ALTER TABLE & MODIFY statement to extend the char limit for the desired column:

 

Working example:

 

http://imgur.com/hkADy4J

ALTER TABLE tablename MODIFY columnname VARCHAR(150);

Edited December 18, 2014 by osherdo