943,929 Members | Top Members by Rank

Web Development > Databases > MySQL > saving image as longblob
Ad:
  • MySQL Discussion Thread
  • Marked Solved
  • Views: 11112
  • MySQL RSS
Permalink
Apr 8th, 2008
0

saving image as longblob

Expand Post »
i'm using vb.net 2005 express + mysql connector to connect to mysql database.
i want to save image into mysql database. so i've created a table with img field as longblob.

to save the image, first i convert it into byte() and then insert into the table.

the problem is the maximum image size it save only 13b
whereas it should be more than that. ??? please, help ?
Reputation Points: 17
Solved Threads: 0
Newbie Poster
bapak is offline Offline
5 posts
since Apr 2008
Permalink
Apr 8th, 2008
0

Re: saving image as longblob

The typical solution to this is not to save the image in the database, but the path to the image (or any large binary file for that matter).

MySQL can handle binary data but it is hardly worth the effort getting it to work - the actual image itself can't be searched or modified by the database anyway, so what's the point of putting it in there?
Reputation Points: 18
Solved Threads: 20
Junior Poster
trudge is offline Offline
176 posts
since Sep 2007
Permalink
Apr 9th, 2008
0

Re: saving image as longblob

MySQL is in my database server while user are connecting to the system from client pc. I want to share the image with other user too.

If i put file path in the table, i don't know what is the correct path to save to make sure all user will have the right path to the image + how will user download the image form the server. ???
Reputation Points: 17
Solved Threads: 0
Newbie Poster
bapak is offline Offline
5 posts
since Apr 2008
Permalink
Apr 9th, 2008
1

Re: saving image as longblob

ha, i got it.
the solution can be found at >>>
http://dev.mysql.com/doc/refman/5.0/...sing-blob.html
Reputation Points: 17
Solved Threads: 0
Newbie Poster
bapak is offline Offline
5 posts
since Apr 2008
Permalink
Oct 30th, 2008
0

Re: saving image as longblob

yes please help I am having the same problem
Reputation Points: 10
Solved Threads: 0
Newbie Poster
moquitto is offline Offline
1 posts
since Oct 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: MySQL Clustering and InnoDB
Next Thread in MySQL Forum Timeline: Logging into Mysql





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC