How can I store an image in a MySQL database using VB.NET?

Question

How can I store an image in a MySQL database using VB.NET? Could you show some examples that use the INSERT command?

miccet · Accepted Answer · 2009-03-27 09:20:05Z

1

Use the BLOB type.

http://forums.mysql.com/read.php?38,6172,15703

answered Mar 27, 2009 at 9:20

miccet

1,9003 gold badges20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

itsmatt · Accepted Answer · 2009-03-27 10:17:41Z

1

Depending on the size of the Image data that you are saving, you'll want to use one of the flavors of the BLOB:

I think the max sizes on them are:

BLOB - 64KB max

MEDIUM BLOB - 16 MB max

LARGE BLOB - 4 GB max

answered Mar 27, 2009 at 10:17

itsmatt

31.5k11 gold badges103 silver badges165 bronze badges

Comments

Lee D · Accepted Answer · 2009-03-27 09:21:40Z

0

I believe the best way to store something like an image in a database is with a BLOB field (Binary Large Object), which is basically just a chunk of data.

Hope this is some help.

answered Mar 27, 2009 at 9:21

Lee D

13k9 gold badges35 silver badges37 bronze badges

Comments

MaxD · Accepted Answer · 2009-07-23 12:37:41Z

0

You can try AccessImagine (http://access.bukrek.net), all you need to do is to bind it to some BLOB field in Properties Inspector.

answered Jul 23, 2009 at 12:37

MaxD

Collectives™ on Stack Overflow

How can I store an image in a MySQL database using VB.NET?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related