What MYSQL data type can hold multiline text data?

[leegold]

This is pretty much a newbie - best practices question:
say a file:

name#1 (start)
line2
line3
...
line14 (end)
name#2
....
name299
....
<eof>

It's really too messy to split into fields, file process and put it in tabular format. Every 14 lines there's a new "record" - I use the term record very loosely because by record I mean one data item eg. The new "records are separated by name# - so when I see a new name# I know it's a new "record". So in mysql I might have one primary key and just one other filed per a record that would be multiline text.

What I an specifically asking is:

What MYSQL data type can hold multiline text data?

Thanks

 

[iranor]

Simple.

In mysql, in the table : Type -> text

 

[leegold]

I see the TEXT data type and the TNYTEXT data type. We are talking about an average paragraph of text about 1/2 a standard page at most. Seems like the TEXT is too big and the TINYTEXT is too small. How do I make sure I have enough so nothing gets truncated, yet not have total overkill - too big a size?

 

[leegold]

One last nagging question will the TEXT type shrink/expand and not give memory or storage problems? If so that would be good.

 

[iranor]

Me I have a mailing system on my website. Sometimes ppl sends message that takes more than 3 pages. I use text.

Text is used when you need multiline and when you want no limit.

 

[KarveR]

You'll be looking for LONGTEXT or BLOB BLOB / TEXT manual page

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.