CODEWITHSUNDEEP
phpmysql
Saravanan I M
Saravanan I M

Reputation: 1155

Longtext data type in PHP

Longtext datatype is the largest capacity(4bytes) datatype in mysql. But it is not enough to store website content page. I’ve tried several times and searched well. And I think MYSQL can able to store maximum of 16KB for Each table. So I’m not able to store all page contents into our table “PAGE”. I’m searching for how to recover this. I’ve worked out with sample text i/p. It works well. But our original contents have more images. Images taking more spaces.

Upvotes: 1

Views: 4505

Answers (2)

Matijs
Matijs

Reputation: 2553

A LONGTEXT field can contain up to 4 Gb per field - less in older MySQL versions.

These values are stored in a separate location from the rest of the record. Only a 4 byte pointer is stored in the record itself, so only those 4 bytes count for the maximum record size.

Mind you: table size, is record size times number of records.

Upvotes: 7

Ben S
Ben S

Reputation: 69342

Have you taken a look at the TEXT and BLOB types?

The maximum size of a table is on the order of terabytes.

Upvotes: 2

Related Questions