Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

For those, like my, that didn't recall off the top of their heads: BLOB in MySQL can usually only hold ~64KB.

EDIT: Though I am curious why MySQL doesn't throw an error when you try to store more than 64KB in BLOB?



The BLOB size limit is a nuisance, the silent truncation is the bug...


It'll give a warning. Many/most MySQL drivers won't interpret it as an error, though.


Huh, I thought BLOB was a backronym for Binary Large OBject, not Binary Medium Object.


There are LONGBLOB, TINYBLOB, etc just like the equivalent TEXT fields




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: