New answers tagged blob
1GB requires LONGTEXT or LONGBLOB. But that datatype may give you headaches. I suggest you experiment with one row with 1GB of data in a column declared LONGTEXT CHARACTER SET ascii. If it is just ASCII, then LONGTEXT makes sense. LONGBLOB would work very similarly. You will probably need to set max_allowed_packet. I have seen a few systems with it set ...
Top 50 recent answers are included