[MySql] Cell Length

[Templarian]

If i know a cell is going to be holding a large amount of data do i just type in the length 999999 (a big number), or is there a way to make it expand larger when it needs too?

Thanks.