MySQL field type question

[Curbow 5]

What field type (varchar, text, etc) would one assign to a field containing a 'large' amount of text? (100k+) Thanks!

[pulpitfire]

text?  (that's a pretty tricky avatar.)

[Curbow 5]

thanx, lol!
doesn't text have a limit to number of chars it can take in? cause that's what i'd like!

[pulpitfire]

well, check here:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_TABLE
http://www.mysql.com/documentation/mysql/bychapter/index.html#BLOB

you might need something like MEDIUMTEXT or LONGTEXT

[Curbow 5]

thanx again! i found my answer! i think i'll go with longblob....
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB

edit: or just mediumblob, since that's still about 2mb.....