store binary data mysql

Question

I want to store igbinary binary serialize data into MySQL. To improve performance is better to use TEXT or BLOB, or etc.

use blob. text field types are subject to character set translation rules, which can/will mangle blob data. other than the charset stuff, blob and text will otherwise perform identically. — Marc B, May 23 '13 at 16:01

score 3 · Accepted Answer · edited May 03 '14 at 22:59

3

When I need to store binary data I always use VARBINARY format.

You can find documentation here

If you are asking what are advantagese, please look here

edited May 03 '14 at 22:59

girardengo

726
12
16

answered May 01 '14 at 10:01

zeppaman

844
8
23

ThomasRedstone · Answer 2 · 2017-11-18T13:15:35.247

2

You should use BLOB, as BLOB stands for Binary Large OBject, if you start storing binary data as text you could start to see all sorts of unexpected results.

There is some documentation explaining the datatypes: http://dev.mysql.com/doc/refman/5.0/en/blob.html

If you really want to store as text, Base64 encoding is what you need to look into, some more details here:

What is base 64 encoding used for?

edited Nov 18 '17 at 13:15

answered May 23 '13 at 17:34

ThomasRedstone

379
1
4
13

store binary data mysql

2 Answers2