retrieving blob from mysql

ronjon

hey guys...

heres my new problem..

im planning to store blobs in a table. if i wanna pull those blobs out of the mysql table and display them... whats the easiest way to do that? i figure i cant just retrieve them via list and store it in one variable...

do i HAVE TO retrieve all the text in smaller chunks? gosh id really hate to do that...seems too complicated and awkward.

so if you guys have any suggestions as to how to store and retrieve large chunks of text....say... two thousand characters or so..... to and from a mysql database...in a simpler and cleaner way than having to parse it in smaller chunks... i would highly appreciate it..

thanks in advance...
ron

bastien

BLOBs or Text? There are differences and you talk about both. BLOBs are Binary Large OBjects like images, psf, and other files. Text can be stored as TEXT in the file. There are diff dispositions required depending on what the item really is (small TEXT, Med Text, Large Text).

ronjon

all i really want to store is text...

im having models post up info about themselves and i wanna post interviews with them.... so.... the text could be extras long paragraphs... i figure... two thousand and above characters for each interview.....

i just want to be able to store and retrieve text without having to parse it.... i hate parsing stuff.... gets me confused....

i guess i just had the idea that texts and blobs were essenstially the same thing...

thanks...

bastien

Use the Meduim Text type...give you all the space you need and no need to parse it out

ronjon

on php?

i figured the problem i was gonna have was ... storing the text into a variable in php right before i display it.

i know of the text data type in mysql that would store the text just fine....

but for example... if i retrieve the text from mysql....and get the text into an array...i want to store it in a variable in php so that i can go:

echo $reallylargechunkoftext;

instead of getting a part of the large chunk of text .... displaying it...then getting the second part...then displaying it... and so on...

is that possible?

its php really that i have a problem with....cause i dont think i can retrieve 2000 character string store it in one variable.... or can i?

i dunno...

i have not tried anything yet because my workstation is at home...and dont have my stuff here at work.... but i just have afeeling that its not gonna work if i try to store it in via list in just any variable in php...

do you know of a simple way of doing it to where i dont have to keep parsing stuff...again i say... i really hate parsing stuff...

thanks again...

-ron

bastien

in php, that is no problem....

$var="largetextitem";
echo $var;

ronjon

so i could do something like

$var = "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";

echo $var;

and it wont truncate it?!

if so... awesome.
thanks abunch... i guess i was just paranoid.

haha!