what's the best field type for large text input?

[stsintzo]

I am trying to figure out what the best choice in field types for large text entries and figured the best way to go is by advice from those who have tried it themselves. Any ideas? (and if anyone could point me to a resource that describes how to out put the entries in the same format that was input that would also be great). Thanks.

[Mordecai]

LONGTEXT is the best. This also works well for encrypted messages (those get a bit lengthy, fast). If you're not looking for something quite so large, use MEDIUMTEXT. If you're looking for a small value, use TINYTEXT.
You can also use BLOB data. This is kind of just an "alternative" to other fields, in case something doesn't really fit any other data types (like images).

[Sxooter]

If you're on Postgresql there's text and varchar() with empty parens. they are both functionally equivalent, and provide AUTOMATIC gz compression with no need for read only tables or anything.

Max size is 1 Gigabyte or so.