anon Posted December 26, 2007 Share Posted December 26, 2007 Hi, i have a field in my table called "content". It is TEXT. thing is, how do i get it so that the amount of characters it asks you to specify is unlimited? Using phpMyadmin. Quote Link to comment https://forums.phpfreaks.com/topic/83283-unlimited-number-of-characters-in-a-field/ Share on other sites More sharing options...
revraz Posted December 26, 2007 Share Posted December 26, 2007 No such thing as unlimited. All fields will have some sort of limit due to DB constraints. Quote Link to comment https://forums.phpfreaks.com/topic/83283-unlimited-number-of-characters-in-a-field/#findComment-423718 Share on other sites More sharing options...
AndyB Posted December 26, 2007 Share Posted December 26, 2007 Just set it as 'text' and leave the 'size' blank. The default limit is 65000+ Is that enough? Quote Link to comment https://forums.phpfreaks.com/topic/83283-unlimited-number-of-characters-in-a-field/#findComment-423721 Share on other sites More sharing options...
wrong_move18 Posted December 27, 2007 Share Posted December 27, 2007 There is no unlimited data type. If you want a much larger capacity you can use a LONGTEXT type. It can store more than 4 Billion characters. Reference: http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html Quote Link to comment https://forums.phpfreaks.com/topic/83283-unlimited-number-of-characters-in-a-field/#findComment-423991 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.