[Help] SQL files don't work

[LMSIMDIIII]

The SQL commands aren't working for my Structure.SQL files.



[Err] 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 'collate utf8_unicode_ci NOT NULL default '',
`password` varch
[Err] CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL auto_increment,
`login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`password` varchar(28) collate utf8_unicode_ci NOT NULL default '',
`encrypted_password` varchar(40) collate utf8_unicode_ci NOT NULL default '',
`gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
`banned` int(1) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
`lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`flags` int(11) unsigned NOT NULL default '0',
`forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
`muted` int(30) NOT NULL default '0',
`banreason` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[Msg] Finished - Unsuccessfully



That's what it looks like when I try to Execute the file through Navicat


I need an answer please -_-" I've been posting everywhere and searching google for a good 3 weeks now.

[Gordge]

Your MySQL is not configured for the UTF-8 Charset...

[LMSIMDIIII]

My database isn't working!....All files are formatted to my MySQL user and pass which is test/test, my stupid wolrdserver.exe says my logon files and world files don't have the correct information and im using AC-web repacks/ original Arc-emu repacks.

[Gordge]

the file ipban.frm seems to be damaged

[LMSIMDIIII]

Well Gordge, since your the only who replied, i'd like to thank you for your imput atleast -_-". I fixed my problem after using phpmyadmin instead of running the SQL files in navicat D:!