Blob

[Manat]

Hello all,

I have a page which displays dynamic data. One of the fields in the database is a BLOB, are there any issues with this?

It seems that whenever there is alot of data in the BLOB, like over 500bytes worth, it doesn't display the information on the page. The php variable in which I store the BLOB data, should I be doing something to it to allow for more bytes of information to be stored into it?

One of the records is like 600bytes, any issues with this?

Thanks
MK

[laserlight]

hmm 500 bytes would only be 500 characters, assuming single byte characters.

I've been able to handle more than that in TEXT fields, which should correspond to BLOB fields in size.

What if you try LONGBLOB, just to test?

[Manat]

No, still nothing.
There is no problem in the DB, it's on the code side.
I'm thinking the variable cannot hold it properly....

I have changed the data type to TEXT from BLOB.