Manixat Posted March 28, 2013 Share Posted March 28, 2013 Hello mysql freaks, I have a few columns of type TEXT. Whenever a record is saved all those fields become [bLOB - BLABLA] and I can not see what is in that field. Why is that and how can I reveal the string behind that label or whatever it is ? Quote Link to comment https://forums.phpfreaks.com/topic/276277-text-rows-unreadable/ Share on other sites More sharing options...
trq Posted March 28, 2013 Share Posted March 28, 2013 Can we see the output of: show create table tablenameDon't forget to tell use the name of the columns that are giving you grief. Quote Link to comment https://forums.phpfreaks.com/topic/276277-text-rows-unreadable/#findComment-1421710 Share on other sites More sharing options...
Manixat Posted March 28, 2013 Author Share Posted March 28, 2013 (edited) In my attempt to for fulfill your request I accidentally solved my problem. See in phpmyadmin, right over where the table starts ( in browsing mode ) there's a pop-up-like menu labeled Options where I checked Show BLOB contents and the values appeared. But still I'm interested to understand what's the purpose of those not being shown? I mean, why is there an option like that? Edited March 28, 2013 by Manixat Quote Link to comment https://forums.phpfreaks.com/topic/276277-text-rows-unreadable/#findComment-1421711 Share on other sites More sharing options...
Solution Psycho Posted March 28, 2013 Solution Share Posted March 28, 2013 (edited) Because a BLOB/TEXT field type is meant for a very large amount of data. PHPMyAdmin is trying to help you by not automatically displaying what would likely be a large amount of text in a table output - which would likely make the page unreadable. Let's say you were storing the text for an entire report in that field. It would be stupid to output that in the DB management display. If you are not storing LARGE amounts of text in that field you should by using something like VARCHAR with a limit on the number of characters. http://help.scibit.com/mascon/masconMySQL_Field_Types.html Edited March 28, 2013 by Psycho Quote Link to comment https://forums.phpfreaks.com/topic/276277-text-rows-unreadable/#findComment-1421712 Share on other sites More sharing options...
Manixat Posted March 28, 2013 Author Share Posted March 28, 2013 Because a BLOB/TEXT field type is meant for a very large amount of data. PHPMyAdmin is trying to help you by not automatically displaying what would likely be a large amount of text in a table output - which would likely make the page unreadable. Let's say you were storing the text for an entire report in that field. It would be stupid to output that in the DB management display. If you are not storing LARGE amounts of text in that field you should by using something like VARCHAR with a limit on the number of characters. http://help.scibit.com/mascon/masconMySQL_Field_Types.html Makes perfect sense. I would use VARCHAR because most of my records will be less than even 100 characters, but every now and then a longer one will be inserted and therefore I need to use the TEXT type, unfortunately. Unless there's any other way of allowing exceptions but I strongly doubt that. Anyway thank you for your replies! Quote Link to comment https://forums.phpfreaks.com/topic/276277-text-rows-unreadable/#findComment-1421713 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.