How to save the image blob data into the database??

[Gokulnathvc]

I am using the following code:
I am reading the jpeg image in Qbytearray; But while saving to database, the image size is doubled and while retrieving from database, the file is being corrupted. How to read the image properly??

QByteArray buf=NULL;
            originalPixmap =QPixmap();
            originalPixmap = QPixmap::grabWindow(QApplication::desktop()->winId());
            QString strfname;
            strfname.sprintf("%d",c);
            originalPixmap.save("C:\\Program Files\\image"+strfname+".jpeg","jpeg");            
            c++;
            char Data;
            QFile file("C:\\Program Files\\image"+strfname+".jpeg");
            file.open(QIODevice::ReadOnly);
            int len=file.size();
            //buf=file.read(len);
            buf=file.readAll();            
            file.close();
            file.remove();            
            QSqlQuery query;
            query.exec("INSERT INTO log (grab_date, ip_address, image,logged_user) "
                          "VALUES (?,?,?,?)");
            query.bindValue(0,dd);
            query.bindValue(1,address);
            query.bindValue(2,buf.toBase64());
            query.bindValue (3,hostname);
            bool qry=query.exec();

QByteArray buf=NULL;
            originalPixmap =QPixmap();
            originalPixmap = QPixmap::grabWindow(QApplication::desktop()->winId());
            QString strfname;
            strfname.sprintf("%d",c);
            originalPixmap.save("C:\\Program Files\\image"+strfname+".jpeg","jpeg");            
            c++;
            char Data;
            QFile file("C:\\Program Files\\image"+strfname+".jpeg");
            file.open(QIODevice::ReadOnly);
            int len=file.size();
            //buf=file.read(len);
            buf=file.readAll();            
            file.close();
            file.remove();            
            QSqlQuery query;
            query.exec("INSERT INTO log (grab_date, ip_address, image,logged_user) "
                          "VALUES (?,?,?,?)");
            query.bindValue(0,dd);
            query.bindValue(1,address);
            query.bindValue(2,buf.toBase64());
            query.bindValue (3,hostname);
            bool qry=query.exec();

To copy to clipboard, switch view to plain text mode 

[FelixB]

please post in one of your 1214234 other thread on this topic.

please stop creating new threads to the same topics again and again.

[Gokulnathvc]

Please try to fix my problem

[wysota]

Learn what base64 is and how it works. And stop spawning threads on the same subject, this is really annoying.

[DanH]

You're saving the data in base64. As I understand it, there should be no need to do that if the field is defined as a blob.

If you saved it in base64, though, you need to translate it out of base64 on retrieval. Eg, use QByteArray.fromBase64.

[Gokulnathvc]

If i save the image just as QByteArray, How it should be retrieved??

[wysota]

The same way, as a byte array. Just make sure the database doesn't perform any conversions when you store the data.