Jump to content


Photo

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


  • Please log in to reply
2 replies to this topic

#1 Area_51

Area_51
  • Members
  • PipPip
  • Member
  • 18 posts

Posted 23 January 2003 - 04:50 PM

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

#2 OhLordy

OhLordy
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationSurrey/England

Posted 23 January 2003 - 05:21 PM

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:

#3 Area_51

Area_51
  • Members
  • PipPip
  • Member
  • 18 posts

Posted 23 January 2003 - 06:47 PM

woah! thats cool! mySQL is a really handy database then. So basically in one column/field i can right a whole essay right?

Thanks for the reply, it was much appreciated.

8)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users