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. Quote Link to comment 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. Quote Link to comment 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 ; Quote Link to comment Share on other sites More sharing options...
otuatail Posted October 11, 2007 Author Share Posted October 11, 2007 Thanks to all who helped Quote Link to comment 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.