how can I get size of data in BLOB?

[email protected] (Igor Mikhailov)
Newsgroups php.general
Message-ID <[email protected]>
I store pictures in mysql BLOBs.
1) when I use something link this:
-------------------
$res=mysql_query("select myPicture from pictures where id=12",$link);
$row=mysql_fetch_array;
-------------------
what type will be variable $row['myPicture']?

2) how cat I get size of $row['myPicture']?
3) does "readfile($filename)" function keep $filename file opened until
client get it? i.e. if I have myDoc.pdf (2MB size), execute
"readfile("myDoc.pdf")", and client recieve this file with 2kb/sec speed.
Does it mean "mysDoc.pdf" will be open about 1000 seconds?

With best regards,
                  Igor Mikhailov.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.