DrByte,
Thank You for your advice that i have done it with your advice. This is what i have done to create the data base :
Original Sql file :
Code:
CREATE TABLE `2checkout` (
`2co_id` int(11) NOT NULL auto_increment,
`start_time` datetime NOT NULL default '0000-00-00 00:00:00',
`finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
`status` varchar(50) collate latin1_general_ci NOT NULL default '',
`return_md5` text collate latin1_general_ci NOT NULL,
`amount` float NOT NULL default '0',
`2co_order_id` int(11) NOT NULL default '0',
`session_id` varchar(50) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`2co_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
After Deleting some command:
Code:
CREATE TABLE `2checkout` (
`2co_id` int(11) NOT NULL auto_increment,
`start_time` datetime NOT NULL default '0000-00-00 00:00:00',
`finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
`status` varchar(50) NOT NULL default '',
`return_md5` text NOT NULL,
`amount` float NOT NULL default '0',
`2co_order_id` int(11) NOT NULL default '0',
`session_id` varchar(50) NOT NULL default '',
PRIMARY KEY (`2co_id`)
) ENGINE=MyISAM;
i'm not sure if there will be any problem by deleting off all of the collate. I was thinking if there is anyone who having the same problem as me i think this could help abit. Please advice will there be any problem with the SQL file i change. Thank You.
Bookmarks