وعند تغير جميع التراميز الى utf8_general_ci ثم رفعت قاعدة البيانات ضهر لي هذا

خطأ

استعلام SQL:

CREATE TABLE `pbb_addons` (

`id` int( 9 ) NOT NULL AUTO_INCREMENT ,

`name` varchar( 250 ) COLLATE utf8_general_ci NOT NULL ,

`title` varchar( 250 ) COLLATE NOT NULL ,

utf8_general_ci `version` varchar( 25 ) COLLATE utf8_general_ci NOT NULL ,

`description` text COLLATE utf8_general_ci NOT NULL ,

`author` varchar( 250 ) COLLATE utf8_general_ci NOT NULL ,

`url` varchar( 350 ) COLLATE utf8_general_ci NOT NULL ,

`installcode` text COLLATE utf8_general_ci NOT NULL ,

`uninstallcode` text COLLATE utf8_general_ci NOT NULL ,

`module_index` mediumtext COLLATE utf8_general_ci NOT NULL ,

`module_admin` mediumtext COLLATE utf8_general_ci NOT NULL ,

`active` smallint( 5 ) unsigned NOT NULL DEFAULT '1',

`languagevals` longtext COLLATE utf8_general_ci NOT NULL ,

PRIMARY KEY ( `id` ) ) ENGINE = MYISAM AUTO_INCREMENT =55 DEFAULT CHARSET = latin1 COLLATE = utf8_general_ci;

MySQL قال:

<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 'NOT NULL, utf8_general_ci `version` varchar(25) COLLATE utf8_general_ci NOT NULL' at line 4</code>