dbo Posted November 17, 2007 Share Posted November 17, 2007 Anyone ever used InnoDB storage engine and try to insert into BLOB fields with phpMyAdmin. For some reason it won't do it, due to some guess at a row count? Quote Link to comment https://forums.phpfreaks.com/topic/77690-solved-phpmyadmin-innodb-insert-into-blob/ Share on other sites More sharing options...
axiom82 Posted November 17, 2007 Share Posted November 17, 2007 Can you use the TEXT datatype? Quote Link to comment https://forums.phpfreaks.com/topic/77690-solved-phpmyadmin-innodb-insert-into-blob/#findComment-393289 Share on other sites More sharing options...
dbo Posted November 17, 2007 Author Share Posted November 17, 2007 Nope, it's an image. Quote Link to comment https://forums.phpfreaks.com/topic/77690-solved-phpmyadmin-innodb-insert-into-blob/#findComment-393292 Share on other sites More sharing options...
axiom82 Posted November 17, 2007 Share Posted November 17, 2007 What about storing the image as a file and using varchar(128) to hold the file path? Quote Link to comment https://forums.phpfreaks.com/topic/77690-solved-phpmyadmin-innodb-insert-into-blob/#findComment-393305 Share on other sites More sharing options...
dbo Posted November 17, 2007 Author Share Posted November 17, 2007 Nopers, I'm one of those guys who argues for storing them in the DB. It's okay, I got sick of messing with it and just wrote my own function to directly insert the stuff and bypass phpMyAdmin. Quote Link to comment https://forums.phpfreaks.com/topic/77690-solved-phpmyadmin-innodb-insert-into-blob/#findComment-393317 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.