On Mon, 14 Jan 2013 17:48:32 +0100, Brad Jorsch bjorsch@wikimedia.org wrote:
On Mon, Jan 14, 2013 at 9:49 AM, Matma Rex matma.rex@gmail.com wrote:
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.
Huh. I guess I was under the mistaken impression that MySQL is reasonable. Thanks for the clarification.
(I just checked the default size limits for similar fields on SQLite and Postresql: 1 gigabyte for both. Yay for MySQL.)