gaogier Posted August 18, 2010 Share Posted August 18, 2010 hello I have a website thats powered by php and mysql. I currently can't add any more info into the mysql database. The main body is too large, its a text type, not int, varchar, or anything else. Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/ Share on other sites More sharing options...
fenway Posted August 18, 2010 Share Posted August 18, 2010 Say what? Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1100991 Share on other sites More sharing options...
gaogier Posted August 19, 2010 Author Share Posted August 19, 2010 how do I make a text field bigger/hold more info? Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101184 Share on other sites More sharing options...
PFMaBiSmAd Posted August 19, 2010 Share Posted August 19, 2010 You haven't provided any specific information as to what the field size/definition is now? What if you are already using the largest size for that field type and cannot increase it and must alter your concept of how you are storing data? Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101187 Share on other sites More sharing options...
gaogier Posted August 19, 2010 Author Share Posted August 19, 2010 Just the field type text it hold 64kb. Is there anyway to expand this? You know what I mean now? other field types, INT, varchar, ect. Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101189 Share on other sites More sharing options...
mikosiko Posted August 19, 2010 Share Posted August 19, 2010 type TEXT limit is 65535 characters you can change your field to a MEDIUMTEXT datatype for a maximum of 16777215 characters or to a LONGTEXT datatype for a maximum of 4294967295 characters Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101237 Share on other sites More sharing options...
fenway Posted August 20, 2010 Share Posted August 20, 2010 type TEXT limit is 65535 characters Not even remotely true -- that's VARCHAR you're talking about, as of mysql 5_. Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101693 Share on other sites More sharing options...
mikosiko Posted August 20, 2010 Share Posted August 20, 2010 Not even remotely true -- that's VARCHAR you're talking about, as of mysql 5_. sure you are right... I was to drunk yesterday Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101707 Share on other sites More sharing options...
mikosiko Posted August 20, 2010 Share Posted August 20, 2010 Fenway... could you please point me where do you got that information? I just checked the 5.6 Manual and it say that the limit for a TEXT field can not exceed 2 to the power of 16 ie. 65536 bytes... and I did test it in my machine with version 5.1.44 and that is correct... a TEXT field cannot exceed the limit maybe I'm not seeing something relevant in the manual. thank you. Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1101771 Share on other sites More sharing options...
fenway Posted August 22, 2010 Share Posted August 22, 2010 My apologies -- I was thinking of LONGTEXT, not TEXT. You were correct -- and I wasn't even drunk Quote Link to comment https://forums.phpfreaks.com/topic/211089-mysql-type-text-question/#findComment-1102213 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.