utf8 a csv misto hacku a carek otazniky

zdravim projizdel sem fora jak vyresit nacitani z .csv souboru nicmene vetsinou mely vsichni problem u funkce fgetcsv() ze pokud mely prvni znak s diakritikou tak ho to vynechalo me to ovsem neveme zadnej misto toho mi to hazi otazniky


- stranka je v utf-8
- u csv sem nenasel kede nastavit kodovani (jestli to vubec jde)
- posilam data do databaze a tabulky s formatovanim utf-8 bin
- staranky sou na linuxovym servru ...

tohle je muj kod


$row = 1;
$handle = fopen("test.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
// echo "<p> $num fields in line $row: <br /></p>\n";
$row++;
for ($c=0; $c < $num; $c++) {


$explodovano = explode(";",$data[$c]);


$queryinsert = "INSERT INTO xls (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x) VALUES ('" . $explodovano[0] . "', '" . $explodovano[1] . "',
'" . $explodovano[2] . "', '" . $explodovano[3] . "',
'" . $explodovano[4] . "', '" . $explodovano[5] . "',
'" . $explodovano[6] . "', '" . $explodovano[7] . "',
'" . $explodovano[8] . "', '" . $explodovano[9] . "',
'" . $explodovano[10] . "', '" . $explodovano[11] . "',
'" . $explodovano[12] . "', '" . $explodovano[13] . "',
'" . $explodovano[14] . "', '" . $explodovano[15] . "',
'" . $explodovano[16] . "', '" . $explodovano[17] . "',
'" . $explodovano[18] . "', '" . $explodovano[19] . "',
'" . $explodovano[20] . "', '" . $explodovano[21] . "',
'" . $explodovano[22] . "', '" . $explodovano[23] . "' );";

$resultinsert = mysqli_query($link, $queryinsert)
or die(mysqli_error($link));




}
}
fclose($handle);


pokud nekdo vite co stim tak prosim poradte diky

tak chyba byla v nastaveni databaze nicmene prepnul sem ji taky do utf-8 bin ted mi to znaky s diakritikou vynechava at sou kdekoliv