грешка при create table mysql

[IzKuFeLiQqQqQ]

SQL query:

CREATE TABLE `test` (
`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 250 ) cp1251_bulgarian_ci NOT NULL default '',
`gsm` varchar( 250 ) cp1251_bulgarian_ci NOT NULL default '',
`email` varchar( 250 ) cp1251_bulgarian_ci NOT NULL default '',
PRIMARY KEY ( `id` )
)

MySQL said: Documentation
#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 'cp1251_bulgarian_ci NOT NULL default '',
`gsm` varchar(250) cp1251_bulgarian_ci' at line 3

по този http://web-tourist.net/login/login/view.php?st=2052 урок го правя

 

[gLaVoReZa]

CREATE TABLE `test` (
`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 250 ) cp1251_bulgarian_ci NOT NULL default '',
`gsm` varchar( 250 ) cp1251_bulgarian_ci NOT NULL default '',
`email` varchar( 250 ) cp1251_bulgarian_ci NOT NULL default ''
PRIMARY KEY ( `id` )
)

 

[nom3r1]

CREATE TABLE `test` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(250) collate cp1251_bulgarian_ci NOT NULL default '',
  `gsm` varchar(250) collate cp1251_bulgarian_ci NOT NULL default '',
  `email` varchar(250) collate cp1251_bulgarian_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

 

[IzKuFeLiQqQqQ]

glavorez пак даде грешката

nom3r1 стана благодаря +1 :?: