Take the 2-minute tour ×

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

share|improve this question
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
add comment

1 Answer

You should use BLOB, as blog 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

share|improve this answer
add comment

Your Answer


