What is the maximum amount of data allowed for mySQL field?
Posted 23 January 2003 - 04:50 PM
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,
Posted 23 January 2003 - 05:21 PM
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:
Posted 23 January 2003 - 06:47 PM
Thanks for the reply, it was much appreciated.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users