Column length too big for column 'address' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS `jds2g_locatePlace` ( `id` int(11) NOT NULL auto_increment, `name` varchar(500) NOT NULL, `address` varchar(2000) NOT NULL default '', `lat` double NOT NULL default '0', `lng` double NOT NULL default '0', `catid` int NOT NULL default '1', `phone` varchar(2000) NOT NULL default '', `website` varchar(2000) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;