How to save the blob data in MYSQL BLOB field?

Question

0.00/5 (No votes)

See more:

Am using the following code to get the blob data from the image file stored in the local disk.. I want to save that blob data into the blob field of database.

CLongBinary m_BLOBImage;
	CFileStatus fileStatus;
	strfile.GetStatus(fileStatus);
        CString m_BLOBName = strfile.GetFileTitle();
        m_BLOBImage.m_dwDataLength = fileStatus.m_size;
	SIZE_T dwbytes=(SIZE_T)fileStatus.m_size;
        HGLOBAL hGlobal		= GlobalAlloc(GPTR,dwbytes);
        m_BLOBImage.m_hData = GlobalLock(hGlobal);
	strfile.Read(dbImages.m_BLOBImage.m_hData,(UINT)fileStatus.m_size);

How to use the CRecordSet to save this blob data found in m_BlobImage.m_hData to the blob field in the database.

Posted 20-Jun-11 18:28pm

Gokulnath007

Updated 22-Jun-11 0:05am

v2

Add a Solution

Comments

[no name] 21-Jun-11 2:20am

is it that you want to save Image to Sql table??

Gokulnath007 21-Jun-11 3:21am

yes, dbImages.m_BLOBImage.m_hData contains the binary data. I want to store this into the MYSQL blob field.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KarstenK · Answer 1 · 2011-06-21T02:10:00

Solution 1

if the data is big it may be better to create a seperate file and only save the link/psth to it. ->performance

Posted 21-Jun-11 2:10am

KarstenK

Comments

Gokulnath007 21-Jun-11 9:40am

m_BLOBImage.m_hData has the blob data, the only thing is to save this to the blob field of the MYSQL Database.

KarstenK 21-Jun-11 9:50am

why dont you copy the file somewhere in a storage which belongs to the database? This is common practice in database managment systems.

Dont ferget that it raises the speed because that data isnt in the db so it isnt transfered in operations.

Gokulnath007 22-Jun-11 0:54am

I want to save the blob data with out making any change should be saved in the blob field of the MYSQL Database.