PHP-MySQL: Slovenske znaky

 CREATE TABLE `xxx`.`forum` (
`number` TINYINT NOT NULL AUTO_INCREMENT ,
`nick` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL ,
`text` TEXT CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL ,
`date` VARCHAR( 18 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL ,
PRIMARY KEY ( `number` )
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_slovak_ci

SET NAMES 'utf8';

mysql_query('SET NAMES UTF8');
  mysql_query('SET COLLATION_CONNECTION=UTF8_SLOVAK_CI');

cp1250_czech_cs

<?php
mysql_connect("localhost", "xxx", "xxx") or die(mysql_error());
mysql_select_db("sksbc") or die(mysql_error());
$nick = $_POST['nick'];
$text = $_POST['text'];
$date = date('G:i - j.m.Y');
$sct = $_POST['sct'];
if ($nick!="" and $text!="" and $sct=="xxx" and $text!=$text1 and $nick!="Váš nickname..." and $text!="Váš príspevok...")
{
mysql_query ("INSERT INTO `forum` SET nick='$nick', text='$text', date='$date'")
or die(mysql_error());
echo "Váš príspevok bol úspešne odoslaný<br/>";
} elseif ($nick=="" or $nick=="Váš nickname...") {
echo "Nezadal si nick";
} elseif ($text=="") {
echo "Nezadal si text príspevku";
} elseif ($sct=!"xxx") {
echo "Prelomená ochrana pred spambotmi";
} elseif ($text==$text1) {
echo "Zadal si rovnaký text, ako predchádzajúci užívateľ";
}
mysql_close();
?>

<?php
mysql_connect("localhost", "xxx", "xxx") or die(mysql_error());
mysql_select_db("sksbc") or die(mysql_error());
if (isset($_GET['start']) && ereg("^[0-9]+$", $_GET['start'])) {
   $start=$_GET['start'];
} else {
  $start=0;
}
$rows=10;
mysql_query("SET NAMES 'utf8'");
$pocet = mysql_query("SELECT COUNT(*) AS c FROM `forum`");
$pocet = mysql_fetch_assoc($pocet);
$pocet = $pocet['c'];
$vypis = mysql_query("SELECT nick, text, date FROM `forum` ORDER BY number DESC LIMIT $start,$rows");
if (mysql_num_rows($vypis) > 0)
{
  while($riadok = mysql_fetch_assoc($vypis)) {
    echo "<div class=\"forum-head\"><span class=\"forum-nick\">".$riadok['nick']."</span>";
    echo "<span class=\"forum-date\">".$riadok['date']."</span></div><br clear=\"right\"/>";
    echo "<p class=\"forum-text\">".$riadok['text']."</p>";
  }
}
echo "<div id=\"pocitadlo\">";
$num_buttons=ceil($pocet/$rows);
$button = '';
for ($i = 1; $i <= $num_buttons; $i++)
{
  $y=($i-1)*$rows;
  if ($y==$start){
  }
  $button.= "&nbsp;[ <a href=\"?start=$y\">$i</a>&nbsp;]";
  if ($y==$start){
  }
}
echo "$button<br/>";
echo "</div>";
echo(mysql_error());
?>

<meta http-equiv="content-type" content="text/html; charset=windows-1250" />
<meta http-equiv="content-language" content="sk" />

mysql_query("SET CHARACTER SET utf8");

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

http://sepeter.sk/navody-nastavenie-kodovania

mysql_query("SET NAMES latin2");