22.07.2015, 15:47
The rule of thumb for databases is: don't store more than one value in a single field. If you need three different texts then you will need three different rows.
The TEXT type can store up to 65,536 characters, which should be plenty. Beyond that you have MEDIUMTEXT which can store about 1.6 million characters and LONGTEXT which can store 4.2 million characters. However it should be noted that column types should be made as small as possible. If you're going to declare every column as a text you're going to have a bad time.
The TEXT type can store up to 65,536 characters, which should be plenty. Beyond that you have MEDIUMTEXT which can store about 1.6 million characters and LONGTEXT which can store 4.2 million characters. However it should be noted that column types should be made as small as possible. If you're going to declare every column as a text you're going to have a bad time.