phpretard Posted August 29, 2008 Share Posted August 29, 2008 I get the message below and don't know what to do about it. "Because of its length, this field might not be editable" ...and of course not all of the data is entered. Any suggestions? Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/ Share on other sites More sharing options...
DeanWhitehouse Posted August 29, 2008 Share Posted August 29, 2008 I think its 500 chars Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628941 Share on other sites More sharing options...
phpretard Posted August 29, 2008 Author Share Posted August 29, 2008 That's definatly way off. I know it holds at least 1900. What Need help with is what to do when I heve reached the max or at least what the max is. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628950 Share on other sites More sharing options...
DeanWhitehouse Posted August 29, 2008 Share Posted August 29, 2008 Googled: top result MySQL text limits Today’s scary discovery: MySQL TEXT fields have a limit of 65000 bytes. If you insert anything larger than that in to a normal TEXT field mySQL will ... simonwillison.net/2002/Aug/1/mysqlTextLimits/ - 13k - Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628959 Share on other sites More sharing options...
akitchin Posted August 29, 2008 Share Posted August 29, 2008 if that's an error through PMA, that could be PMA's restriction and not MySQL's. regardless, as Blade points out, if you have a lot of text to use, adjust your field type to BIGTEXT. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628960 Share on other sites More sharing options...
DarkWater Posted August 29, 2008 Share Posted August 29, 2008 You mean LONGTEXT, right akitchin? =P I think LONGTEXT can handle over 4 trillion. Read it somewhere a while ago. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628963 Share on other sites More sharing options...
akitchin Posted August 29, 2008 Share Posted August 29, 2008 You mean LONGTEXT, right akitchin? =P I think LONGTEXT can handle over 4 trillion. Read it somewhere a while ago. that would be the one. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628980 Share on other sites More sharing options...
DarkWater Posted August 29, 2008 Share Posted August 29, 2008 You mean LONGTEXT, right akitchin? =P I think LONGTEXT can handle over 4 trillion. Read it somewhere a while ago. that would be the one. Lol, I was just thinking that MEGATEXT would be a pretty sick column name. Just sounds so cool for a data type. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-628998 Share on other sites More sharing options...
discomatt Posted August 29, 2008 Share Posted August 29, 2008 http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html tinyblob/text = 2^8 bytes blob/text = 2^16 bytes mediumblob/text = 2^24 bytes longblob/text = 2^32 bytes Depending on your encoding, 1 character usually takes up 1 byte of space. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-629050 Share on other sites More sharing options...
The Little Guy Posted August 29, 2008 Share Posted August 29, 2008 CHAR( ) A fixed section from 0 to 255 characters long. VARCHAR( ) A variable section from 0 to 255 characters long. TINYTEXT A string with a maximum length of 255 characters. TEXT A string with a maximum length of 65535 characters. BLOB A string with a maximum length of 65535 characters. MEDIUMTEXT A string with a maximum length of 16777215 characters. MEDIUMBLOB A string with a maximum length of 16777215 characters. LONGTEXT A string with a maximum length of 4294967295 characters. LONGBLOB A string with a maximum length of 4294967295 characters. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-629088 Share on other sites More sharing options...
jordanwb Posted August 29, 2008 Share Posted August 29, 2008 Lol, I was just thinking that MEGATEXT would be a pretty sick column name. Just sounds so cool for a data type. +1 For MEGATEXT (what about longshort? longbool?). This is good to know regarding how much space a field type can hold. Quote Link to comment https://forums.phpfreaks.com/topic/121896-how-much-information-can-a-database-text-area-hold/#findComment-629093 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.