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
– Marc B, Commented May 23, 2013 at 16:01

girardengo · Accepted Answer · 2014-05-03 22:59:10Z

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 3, 2014 at 22:59

girardengo

72512 silver badges16 bronze badges

answered May 1, 2014 at 10:01

zeppaman

8548 silver badges23 bronze badges

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

Comments

ThomasRedstone · Accepted Answer · 2017-11-18 13:15:35Z

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, 2017 at 13:15

answered May 23, 2013 at 17:34

ThomasRedstone

4081 gold badge6 silver badges14 bronze badges

Collectives™ on Stack Overflow

store binary data mysql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related