should I use text or longtext for table column?

whats the difference? is text() enough?

I just found abuot this: $table->longText('description');

and made me wonder if text alone would be enough for content that can be of any lenght, lets say blog post, which one do you use?

samalapsy

9 years ago

Level 2

It's based on what type of content you're expecting from the user Text has the capacity to hold 65,535 characters which is about 64 KiB of size while LONG TEXT has the capacity to hold 4,294,967,295 characters which is about 4GB of size.

For me I use TEXT.

Hope it's helpful.

Source [http://stackoverflow.com/questions/13932750/tinytext-text-mediumtext-and-longtext-maximum-storage-sizes]

4 likes

nikocraft

9 years ago

Level 8

Is there any performance of memory penalty for defining mediumtext instead of just text? I may go with mediumtext since I do not know in advance what enduser may decide to put into the body of a blog post for example documentation which could be as large as 50 pages book etc. What do you think of mediumtext for such a case @samalapsy ?

samalapsy

9 years ago

Level 2

yes you're right @maxnb. It's very useful when dealing with large contents.

Please or to participate in this conversation.