Mysql errors - Joomla! Forum - community, help and support

when try install task hopper error:

" sql error db function failed error number 1064
you have error in sql syntax. check manual corresponds mysql server version right syntax use near 'character set utf8 collate utf8_bin not null, `needed_by` sql=create table `jos_th_item` ( `item_id` mediumint(10) not null auto_increment, `customer_id` mediumint(3) not null default '0', `item_creator_id` mediumint(3) unsigned not null default '0', `item_type_id` mediumint(3) not null default '0', `item_req_type_id` mediumint(3) not null default '0', `date_opened` varchar(12) not null default '', `date_closed` varchar(12) not null default '', `detailed_desc` longtext character set utf8 collate utf8_bin not null, `needed_by` date not null default '0000-00-00', `attachment` mediumint(3) not null default '0', `project_id` mediumint(3) not null default '0', `urgency_id` mediumint(3) not null default '0', `status_id` mediumint(3) not null default '0', `summary` varchar(100) character set utf8 collate utf8_bin not null, `anonym_email` varchar(30) default null, `start_date` date default null, `updated` date default null, `estimated_hours` double default '0.00', `spent_hours` int(11) not null default '0', primary key (`item_id`) ) type=myisam auto_increment=50;
sql =

create table `jos_th_item` (
`item_id`          mediumint(10) not null auto_increment,
`customer_id`      mediumint(3) not null default '0',
`item_creator_id`  mediumint(3) unsigned not null default '0',
`item_type_id`      mediumint(3) not null default '0',
`item_req_type_id`  mediumint(3) not null default '0',
`date_opened`      varchar(12) not null default '',
`date_closed`      varchar(12) not null default '',
`detailed_desc`    longtext character set utf8 collate utf8_bin not null,
`needed_by`        date not null default '0000-00-00',
`attachment`        mediumint(3) not null default '0',
`project_id`        mediumint(3) not null default '0',
`urgency_id`        mediumint(3) not null default '0',
`status_id`        mediumint(3) not null default '0',
`summary`          varchar(100) character set utf8 collate utf8_bin not null,
`anonym_email`      varchar(30) default null,
`start_date`        date default null,
`updated`          date default null,
`estimated_hours`  double default '0.00',
`spent_hours` int(11) not null default '0',
primary key  (`item_id`)
) type=myisam auto_increment=50;"

can give me directions on how go fixing it?  i've googled , apparently it's error of mysql database, correct?

what mysql version have?

"type=myisam" indicates earlier mysql version "character set utf8 collate utf8_bin" within of other lines.
(newer mysql versions use "engine=myisam" table type).

i remove both "character set utf8 collate utf8_bin" references sql statement, run it.

(always backup database first!)