How to install Joomla 1.0.11 with Mysql 5

Started to get installation errors in step 2 inserting data in the db. Such as:

SQL=BLOB/TEXT column \'text\' can\'t have a default value SQL=# Table structure for table `jos_poll_data`\n\nCREATE TABLE `jos_poll_data` (\n `id` int(11) NOT NULL auto_increment,\n `pollid` int(4) NOT NULL default \'0\',\n `text` text NOT NULL default \'\',\n `hits` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `pollid` (`pollid`,`text`(1))\n) TYPE=MyISAM:- - - - - - - - - -# Table structure for table `#__poll_data`CREATE TABLE `#__poll_data` ( `id` int(11) NOT NULL auto_increment, `pollid` int(4) NOT NULL default '0', `text` text NOT NULL default '', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`,`text`(1))) TYPE=MyISAM= = = = = = = = = =


I tried fixing the joomla.sql file like some of the other posts such as http://forum.joomla.org/index.php/topic,103176.msg522184.html#msg522184 but kept getting more errors. So instead to solve the problem I just launched the Mysql instance config wizard and set the database to not be "strict". The installation worked fine after