how to save a image file ( say png ) into mysql database?

[AviMittal]

i tried the same but it didnt worked.

[spirit]

it works fine for me. what did you try?

[AviMittal]

i am doing it following way..

say have an image file named: apple.png
i opened the file and read it completely using file.readAll(). and saved it into QString (str).
then i converted this QString(str) into QbyteArray and then called toBase64(). and then tried to save it in database and in same way i tried to read it from database but it didnt worked.

Can you share your sample code for this?

thanx

[faldzip]

why are you saving data to QString and then converting it to QByteArray? isn't readAll() alredy returning QByteArray? try to readAll() straight into QByteArray without any QStirings

[AviMittal]

its not working for me

[faldzip]

can you show us your code?

[soxs060389]

Save given QImage directly into QByteArray:

QImage image;
         QByteArray ba;
         QBuffer buffer(&ba);
         buffer.open(QIODevice::WriteOnly);
         image.save(&buffer, "PNG");

QImage image;
         QByteArray ba;
         QBuffer buffer(&ba);
         buffer.open(QIODevice::WriteOnly);
         image.save(&buffer, "PNG");

To copy to clipboard, switch view to plain text mode 

(Taken from Documentation)