Jump to content

text rows unreadable?


Manixat
Go to solution Solved by Psycho,

Recommended Posts

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 ?

Link to comment
Share on other sites

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 by Manixat
Link to comment
Share on other sites

  • Solution

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 by Psycho
Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.