MySQL table creation error - with CHARSET

[Nuwan Gurusinghe]

I have this script to create a table in MySQL.

The version I use is 3.23.56



CREATE TABLE ApplicantEvaluate (
ID int(10) unsigned NOT NULL default '0',
EmployeeID int(10) unsigned NOT NULL default '0',
Evaluation smallint(4) unsigned default NULL,
Reason varchar(100) default NULL,
Opportunity smallint(4) unsigned default NULL,
EvaluDate date default NULL,
Memo varchar(200) default NULL,
HopeMemo varchar(200) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM DEFAULT CHARSET=latin1;

----------------------------------------------------------------------------------
This gives the following error when executing

ERROR 1064: You have an error in your SQL syntax near 'DEFAULT CHARSET=latin1' at line 11
----------------------------------------------------------------------------------

Can somebody please let me know what is the problem with this script. I appreciate a quick reply as thanks in advance.

Cheers

Nuwan