Mysql byte array storage

Question

I have a byte array created in Java. It represents content of some file. I don't know exactly the maximum size of this array. It can be different sizes. I want to store it in mysql. What type should I use in mysql?

Nikson Kanti Paul · Accepted Answer · 2018-04-03 09:35:31Z

25

Use BLOB, medium blob , varbinary

Mysql Choosing the Right Type for a Column

edited Apr 3, 2018 at 9:35

answered Jul 3, 2012 at 10:46

Nikson Kanti Paul

3,4381 gold badge37 silver badges51 bronze badges

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

Comments

Sergey Kalinichenko · Accepted Answer · 2012-07-03 10:34:14Z

8

Use varbinary to store byte arrays of arbitrary length in MySQL.

answered Jul 3, 2012 at 10:34

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

2 Comments

user1379574 Over a year ago

if I use varbinary, what java type should I use for java mapping of the field when i do select? byte[] or string?

Sergey Kalinichenko Over a year ago

@user1379574 use byte[] (here is a link that lists type mappings).

Nikson Kanti Paul · Accepted Answer · 2012-07-03 10:54:37Z

1

use a blob field

java serialblob

mysql blob

edited Jul 3, 2012 at 10:54

Nikson Kanti Paul

3,4381 gold badge37 silver badges51 bronze badges

answered Jul 3, 2012 at 10:40

di3

5943 silver badges10 bronze badges

Collectives™ on Stack Overflow

Mysql byte array storage

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related