 |  |  |  |  |  |  |  |
saving image as longblob
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
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 ?
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 ?
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?
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?
Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"
"Others make web sites. We make web sites work!"
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. ???
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. ???
ha, i got it.
the solution can be found at >>>
http://dev.mysql.com/doc/refman/5.0/...sing-blob.html
the solution can be found at >>>
http://dev.mysql.com/doc/refman/5.0/...sing-blob.html
 |
Other Threads in the MySQL Forum
- Previous Thread: MySQL Clustering and InnoDB
- Next Thread: Logging into Mysql
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 email enter enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opensource oracle php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency
