dezkit Posted April 27, 2008 Share Posted April 27, 2008 what's a good "Type" i should use if i want to write an essay and store in it mysql, should i use varchar(255) ? Quote Link to comment https://forums.phpfreaks.com/topic/103184-solved-mysql/ Share on other sites More sharing options...
mrdamien Posted April 27, 2008 Share Posted April 27, 2008 Unless your essay is only 255 characters or less, you'll want to use something bigger. Pick from these: 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/103184-solved-mysql/#findComment-528523 Share on other sites More sharing options...
dezkit Posted April 27, 2008 Author Share Posted April 27, 2008 Thanks, topic solved, +bookmarked Quote Link to comment https://forums.phpfreaks.com/topic/103184-solved-mysql/#findComment-528530 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.