Filip de Waard wrote:On Mar 20, 2004, at 3:11 PM, charalambos nicolaou wrote:Hi,
I have created a MySQL table with a blob field and I don’t know how to insert an image to it. Help me please because I am going crazy.
Use your filesystem instead, databases might be capable of storing binary data but they are not perfect. Use your filesystem and store the filename in your database.
And what if he has a perfectly good reason to store the data in the db? No offense but you didn't really help him with his query at all.
I can't think of a scenario where storing binary data in a database is the best solution, but I'm sure there are situations where this is an interesting option (since there has to be a reason databases include this option). I haven't found one yet and I'm pretty sure that Charalambos should use the filesystem instead, since that is the correct answer for 99.999% of all cases.
And yeah, search google!
Using Google I found the link that solved his problem in 2 seconds. I told him to use Google next time and gave him the link to his answer. He thanked me for it, for godsake!
I don't have a clue about what reason you have to kick somebody in the groan who is just helping, while you didn't help Charalambos a bit.
Filip de Waard
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php