Tedd, Try this:
DROP TABLE IF EXISTS `xyz`; CREATE TABLE IF NOT EXISTS `xyz` ( `imagename` varchar(30) NOT NULL, `image` blob ) ENGINE=MyISAM;INSERT INTO `xyz` VALUES ('PDF FIle', 0x255044462d312e340d25e2e3cfd30d0a38322);
INSERT INTO `xyz` VALUES ('No Image', NULL);
SELECT `imagename` , `image` , OCTET_LENGTH( `image` )/1024 FROM
`xyz` LIMIT 0 , 30
-- image is the BLOB field. Hope that helps. Dev On 4/4/2011 10:40 PM, tedd wrote:
At 8:41 PM -0500 4/4/11, Allen Shaw wrote:On 04/04/2011 08:12 PM, tedd wrote:I have a record that contains an image in a BLOB field and phpMyAdmin shows that the field is holding 11,3KB of data. Is there a way to determine that size ...How about OCTET_LENGTH() ? http://forums.mysql.com/read.php?52,97093,97117#msg-97117 -- Allen ShawYes, I saw that and this:<http://forums.mysql.com/search.php?52,search=OCTET_LENGTH,author=,page=1,match_type=ALL,match_dates=365,match_forum=ALL,match_threads=>But I till don't know what to do,I guess that I could put queries together and figure it out, but I wanted to ask here first.Thanks, tedd
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
