mysql - should I use text or longtext for table column? -


whats difference? text() enough?

i found abuot this: $table->longtext('description');

and made me wonder if text alone enough content can of lenght, lets blog post, 1 use?

each type manage different max length

varchar(m), varbinary(m) 255 bytes, or more 255 bytes

tinyblob, tinytext l l < 2^8

blob, text l < 2^16

mediumblob, mediumtext l < 2^24

longblob, longtext l < 2^32

https://dev.mysql.com/doc/refman/5.7/en/string-type-overview.html


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -