otuatail Posted October 10, 2007 Share Posted October 10, 2007 I would like to create a CMS for a website and would need a blog. I am confused about the difrence between Text and Blob, Blob being case sensitive for some reason. Also what is the limit on size (I think i'm on 4.0.25) as I see things like comments TEXT(300) does this mean that it padds spaces to 300 unlike VARCHAR. If so what is the advantages speed wise. Desmond. Link to comment https://forums.phpfreaks.com/topic/72645-solved-text-blog/ Share on other sites More sharing options...
fenway Posted October 10, 2007 Share Posted October 10, 2007 Check out the relevant refman page -- TEXT is 65K. Link to comment https://forums.phpfreaks.com/topic/72645-solved-text-blog/#findComment-366359 Share on other sites More sharing options...
otuatail Posted October 10, 2007 Author Share Posted October 10, 2007 I have checked it out and I am still confused about case sensitive as this is something to do with comapring data like a password. also. I have tried to create a table with a blog field but I get an error CREATE TABLE IF NOT EXISTS `blob` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `content` blob( 500 ) default NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM AUTO_INCREMENT =1 #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(500) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; Link to comment https://forums.phpfreaks.com/topic/72645-solved-text-blog/#findComment-366462 Share on other sites More sharing options...
otuatail Posted October 11, 2007 Author Share Posted October 11, 2007 Thanks to all who helped Link to comment https://forums.phpfreaks.com/topic/72645-solved-text-blog/#findComment-366893 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.