Reakce na odpověď

Create Table:

CREATE TABLE `clanky` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `poradi` int(255) NOT NULL,
  `rubrika` int(255) NOT NULL,
  `nazev_clanku` text COLLATE utf8_czech_ci NOT NULL,
  `obsah_clanku` longtext COLLATE utf8_czech_ci NOT NULL,
  `autor` text CHARACTER SET latin1 NOT NULL,
  `datum_pridani` datetime NOT NULL,
  `datum_start` datetime NOT NULL,
  `datum_konec` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

Insert to table:

mysql_query("INSERT INTO clanky (rubrika, datum_pridani, datum_konec, datum_start, nazev_clanku, obsah_clanku, poradi, autor) VALUES ( '".$rubrika."', '".$datum_pridani."', '".$mysql_datum_konec."', '".$mysql_datum_start."', '".$nazev_clanku."', '".$obsah_clanku."', '".$pocet_radku."', '".$autor."');") or die ("This: " .mysql_error());

Při vytvoření připojení s DB:

mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
mysql_query("SET character_set_results=utf8");

MySQL - Diakritika