DEFAULT CHARSET=latin1.

Client Joined: Jan 21, 2006 Posts: 87 Location: Arizona

When I try to import the following SQL

Code:




 CREATE TABLE `nuke_imbl_default` (


  `program` varchar(100) NOT NULL default '',


  `version` varchar(255) NOT NULL default '',


  `theme` varchar(255) NOT NULL default '',


  KEY `program` (`program`)


) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





-- 


-- Dumping data for table `nuke_imbl_default`


-- 





INSERT INTO `nuke_imbl_default` VALUES ('IMBuddyList', '2.0', 'IM_BuddyList_20');





-- 


-- Table structure for table `nuke_imbl_usertheme`


-- 





CREATE TABLE `nuke_imbl_usertheme` (


  `username` varchar(255) collate latin1_general_ci NOT NULL default '',


  `theme` varchar(255) collate latin1_general_ci NOT NULL default '',


  KEY `username` (`username`)


) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

I get this error:

Code:

#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 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 6.

It appears to have something to do with Default CHARSET=latin1. I've searched the forums but I get too many hits (basicaly every piece of code on the forum with that data). Can anyone help explain this. I am hosted by Raven and use whatever MySQL he has setup.

Posted: Wed Mar 15, 2006 7:22 pm

Delete "DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci" - it is not necessary

Posted: Thu Mar 16, 2006 9:20 am

Thank You. I did this and it worked great.