BLOB… on any text columns

[paulsheff]

Hi

I can't get tinytext/text files to display as default, all I'm getting is “BLOB…”

I've tried Ctrl+L and it's showing in Edit>Show Results In Text – as ticked. It's like it thinks there isn't enough space to show it? I'm on XP Pro SP2.

Thanks

[peterlaursen]

Quote:

I can't get tinytext/text files to display as default, all I'm getting is “BLOB…”

Could you explain some more. I don't understand. Best would be to post a screenshot.

There is very little difference of BLOB and TEXT in MYSQL. TEXT have a charset defined with them – BLOBs don't.

You should not expect TEXT to dispay as CHAR or VARCHAR.

[peterlaursen]

BTW: you can't use the CHAR or VARCHAR variable type ? They can be 255 characters long. (With MySQL ver 5 varchars can be +50000 characteres!).

TEXT in MySQL is not all the same as “text” in for instance MS-Access – VARCHAR is!

[paulsheff]

Works fine with varchar, just seems weird, I used to use Navicat and that would display text from MySQL fine?

[peterlaursen]

That is no bug. SQLyog is like that. What Navicat does I don't know.

But you should update SQLyog to 4.07 or 4.1 beta.

BLOB/TEXT colums now will show the beginning of the TEXT (as much as there is room for!)

BLOB/TEXT type are for huge amounts of data. One single medumtext can be 16 MB for instance!

And CHAR/VARCHAR are more effective with MySQL. The reason is that BLOB/TEXT values are not stored in the table itself – only a pointer is stored.

[Ritesh]

Upgrading to 4.07 is the answer.

[Author]

Posts