Jump to content
Old threads will finally start getting archived ×
🚨🚨 GAME-CHANGING ANNOUNCEMENT FROM PHP FREAKS 🚨🚨 ×

What is the maximum amount of data allowed for mySQL field?


DeepSeek 🤖

Recommended Posts

Hello people, I am not sure if this question has come up before so apologies for that. And I can not find this in the documentation either.

 

Can anyone please tell me on what is the maximum data a mySQL column can store? Basically I have to deal with lots of data, and one of the fields is to store at least 1000 words. Can this amount of information be stored in a single cell?

 

If not what is the alternative because somehow i need to display back this information on the browser.

 

Thank you very much for you time and i would be most appreciated if someone can help me on this matter,

 

J

For data types that you do not have to specify the upper limits of there are four (if that sentance didn\'t make sense I\'m sorry)

 

TINYTEXT up to 255 characters

TEXT up to 65535 characters

MEDIUMTEXT up to 16.7million characters

LONGTEXT up to 4billion characters

 

I don\'t know if there is an upper limit for varchar though.

try varchar(99999999999999999999999999999999999999999999999999999999) and see what happens :wink:

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.