Здравейте,искам да попитам как да направя тaзи заявка с чарсет windows-1251? Ето я и заявката:
Код:
CREATE TABLE `subtitles` (
`id` int(9) NOT NULL auto_increment,
`name` varchar(99) collate utf8_unicode_ci NOT NULL default '',
`year` int(10) unsigned NOT NULL default '0',
`file` varchar(99) collate utf8_unicode_ci NOT NULL default '',
`imdb` varchar(200) collate utf8_unicode_ci NOT NULL default '',
`skat` varchar(250) collate utf8_unicode_ci NOT NULL default '',
`comment` text collate utf8_unicode_ci,
`Framerate` varchar(99) collate utf8_unicode_ci NOT NULL default '',
`cds` int(9) NOT NULL default '0',
`type` varchar(40) collate utf8_unicode_ci NOT NULL default 'txt',
`uploader` int(9) NOT NULL default '0',
`downloaded` int(9) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=121 ;
CREATE TABLE `fps` (
`id` int(8) NOT NULL default '0',
`fps` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Дъмп (схема) на данните в таблицата `fps`
--
INSERT INTO `fps` VALUES (1, '15.000');
INSERT INTO `fps` VALUES (2, '20.000');
INSERT INTO `fps` VALUES (3, '23.976');
INSERT INTO `fps` VALUES (4, '24.000');
INSERT INTO `fps` VALUES (5, '25.000');
INSERT INTO `fps` VALUES (6, '29.970');
INSERT INTO `fps` VALUES (7, '30.000');
CREATE TABLE `year` (
`id` int(8) NOT NULL default '0',
`year` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Дъмп (схема) на данните в таблицата `year`
--
INSERT INTO `year` VALUES (1, '2007');
INSERT INTO `year` VALUES (2, '2006');
INSERT INTO `year` VALUES (3, '2005');
INSERT INTO `year` VALUES (4, '2004');
INSERT INTO `year` VALUES (5, '2003');
INSERT INTO `year` VALUES (6, '2002');
INSERT INTO `year` VALUES (7, '2001');
INSERT INTO `year` VALUES (8, '2000');
INSERT INTO `year` VALUES (9, '1999');
INSERT INTO `year` VALUES (10, '1998');
INSERT INTO `year` VALUES (11, '1997');
INSERT INTO `year` VALUES (12, '1996');
INSERT INTO `year` VALUES (13, '1995');