On Mon, Jan 14, 2013 at 9:49 AM, Matma Rex matma.rex@gmail.com wrote:
On Mon, 14 Jan 2013 15:42:35 +0100, Tyler Romeo tylerromeo@gmail.com wrote:
Additionally, one thing we might want to change is at the very least doing a quick length check on userjs- options just to make sure they fit in the database, although it shouldn't really be an issue.
Well, these fields are BLOBs, so any length should work as long as you have enough disk space. ;) The length of the key (which is a VARBINARY(255)) is checked.
Not true, a BLOB can hold 65535 bytes maximum. That's short enough that it probably is worth adding a length check to the API.
See https://dev.mysql.com/doc/refman/5.0/en//blob.html for details.