Serialize data on mysql data types

What is the best data types for seri开发者_运维技巧alize data?

---

if you know how long the serialized data will be you can use varchar, otherwise id use text. it might just be best to use text anyways.

---

It depends on how big the data you want to serialize is. It could be text or longtext.

Btw, very often (but not always) storing of serialized data is a bad design, which should be reimplemented using N:M or 1:N (many-to-many or one-to-many) relations

---

If the data is just a generic pile of bytes, such as an image, then use a BLOB.

If it's a pile of text, use one of the TEXT types.

Otherwise, it depends upon what kind of data you're dealing with.