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 ?
Jump to PostThe 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 …
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 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. ???
ha, i got it.
the solution can be found at >>>
http://dev.mysql.com/doc/refman/5.0/en/connector-net-using-blob.html
yes please help I am having the same problem
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.