My site allows users to submit After Action Reports and yesterday someone set the new record with a ~48,000 character beast of a report. While that's still only 74% of the TEXT maximum character count, it made me wonder what should be done when someone wants to submit something that exceeds the 65k limit...? It's bound to happen eventually...
views:
31answers:
2
A:
you might start storing the data in text or xml files on the server and link to them using sql? either that or use multiple records, i don't see many other options.
daedalus0x1a4
2010-06-26 00:55:30
Storing on the filesystem gets difficult to maintain referential integrity. The topic is a holy war when figuring out how to deal with images...
OMG Ponies
2010-06-26 00:57:01
really? i didn't think anyone stored images as binary. i thought that text and blob have the same limit?
daedalus0x1a4
2010-06-26 00:58:27
+3
A:
You could use one of the larger TEXT types. A LONGTEXT will accept 4 GB of data. A MEDIUMTEXT will store 16 MB of data.
ceejayoz
2010-06-26 01:12:32