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. 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. 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? 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 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
Archived
This topic is now archived and is closed to further replies.