update image column in MySQL
-
I can update regular column with varchar/numeric type, but I when I try to update image data(longblob) in MySQL, but it doesn't work. Can anybody help me on how to do that? Here is my code for this: ProducerConn->Open(); ProducerSide->CommandText = "DROP TABLE IF EXISTS MyDB"; ProducerSide->ExecuteNonQuery(); ProducerSide->CommandText = "CREATE TABLE MyDB (ID timestamp(14), ext varchar(5), image longblob)"; ProducerSide->ExecuteNonQuery(); String * FILE = "image.jpg"; FileStream * tfs = new FileStream(FILE, FileMode::Open, FileAccess::Read); Int16 len = (int)tfs->Length; Byte buffer[] = new Byte[len]; tfs->Read(buffer, 0, buffer->Length); // ProducerSide->CommandText = "update MyDB set image=buffer"; <---- line with problem ProducerSide->CommandText = "UPDATE MyDB set ext='jpg'"; ProducerSide->ExecuteNonQuery(); Thanks!