Такая ситуация:
есть поиск на страничке .php сохраненной в utf-8 без BOM
база в mysql InnoDB utf8_unicode_ci таблица utf8_unicode_ci
Вот страничка поиска
<?php
error_reporting(0);
session_start();
include_once ('./config.php');
$link = mysqli_connect(DB_LOCAL, DB_LOGIN, DB_PASS, DB_NAME)or exit(mysqli_error());
mysqli_set_charset($link,'utf8');
mysql_query("SET NAMES 'utf-8");
mysql_query("SET CHARACTER SET 'utf-8'");
$i = 1;
?>
<head>
<link href="css/style.css" rel="stylesheet" type="text/css">
<script src="jquery.min.js"></script>
<script type="text/javascript">
var auto_refresh = setInterval(
function(){
$('#refreshme').fadeOut('slow').load ('time.php').fadeIn("slow");
}, 1000);
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div class="main">
<div class="stat">
<div class="logo"><a href="index.php"><img src="img/logo.jpg" title="Главная" style="border:none;"></a></div>
<div><form action="in.php" method="post" name="out1"><input type="submit" value="Выход" name="out" class="out"></form></div>
<div class="size"><?php echo date("Y.m.d ");?></div>
<div id="refreshme" class="size"><?php echo ' '.date(" G:i:s");?></div>
<div class="priv"><?php echo '<br><br><br><br><br>Добро пожаловать <ins>'.$name.'</ins>'; ?></div>
<div class="poisk"><form action="" method="post"><input type="submit" name="1" value="поиск" id="sub"><input type="text" name="search" id="search"></form></div>
<table cellpadding="0" cellspacing="0" border="0px" class="woi col">
<tr align="center">
<th width="30px"></th>
<th width="30px"></th>
<th width="50px">№</th>
<th width="110px">Продукция</th>
<th width="50px">кол-во</th>
<th width="160px">Коментарии</th>
<th width="90px">Покупатель</th>
<th width="90px">Дата <br>готовности продукции</th>
<th width="90px">Дата <br>отгрузки продукции</th>
<th width="80px">Вид <br>доставки</th>
<th width="50px">Очередь</th>
<th width="50px">Номер заказа</th>
<th width="160px">Прочее</th>
<th width="90px">Дата и время<br>Редактирования</th>
<th width="90px">Кто редактировал</th>
</tr></table></div>
<div class="content-a">
<table cellpadding="0" cellspacing="0" border="1px" class="woi">
<?php
$ser = $_POST['search'];
$ser = iconv("utf-8", "utf-8//IGNORE", $_POST['search']);
if(isset($_POST['search'])) {
$res = mysqli_query($link,"SELECT * FROM `work` WHERE `id` LIKE '%$ser%' OR `product` LIKE '%$ser%' OR `amount` LIKE '%$ser%' OR `comment_manager` LIKE '%$ser%' OR `buyer` LIKE '%$ser%' OR `date_ready` LIKE '%$ser%' OR `date_shipping` LIKE '%$ser%' OR `delivery` LIKE '%$ser%' OR `turn` LIKE '%$ser%' OR `number` LIKE '%$ser%' OR `other` LIKE '%$ser%' OR `date` LIKE '%$ser%' OR `editor` LIKE '%$ser%' ORDER BY `date_shipping` DESC, `id` DESC") or exit (mysqli_error());
while ($row = mysqli_fetch_assoc($res)) {
$names = $i++;
echo '<tr align="center">
<td><div class="num1">'.$row['id'].'</div></td>
<td><div class="td1">'.stripslashes($row['product']).'</div></td>
<td><div class="num1">'.$row['amount'].'</div></td>
<td><div class="kom1">'.stripslashes($row['comment_manager']).'</div></td>
<td><div class="pok1">'.stripslashes($row['buyer']).'</div></td>
<td><div class="pok1">'.$row['date_ready'].'</div></td>
<td><div class="pok1">'.$row['date_shipping'].'</div></td>
<td><div class="dost1">'.stripslashes($row['delivery']).'</div></td>
<td><div class="num1">'.$row['turn'].'</div></td>
<td><div class="num1">'.$row['number'].'</div></td>
<td><div class="kom1">'.stripslashes($row['other']).'</div></td>
<td><div class="pok1">'.$row['date'].'</div></td>
<td><div class="pok1">'.$row['editor'].'</div></td>';
}
exit();
}
else {
$res = mysqli_query($link,"SELECT * FROM `work` WHERE 1 ORDER BY `date_shipping` DESC, `id` DESC") or exit (mysqli_error());
while ($row = mysqli_fetch_assoc($res)) {
$names = $i++;
echo '<tr align="center">
<td><div class="num1">'.$row['id'].'</div></td>
<td><div class="td1">'.stripslashes($row['product']).'</div></td>
<td><div class="num1">'.$row['amount'].'</div></td>
<td><div class="kom1">'.stripslashes($row['comment_manager']).'</div></td>
<td><div class="pok1">'.stripslashes($row['buyer']).'</div></td>
<td><div class="pok1">'.$row['date_ready'].'</div></td>
<td><div class="pok1">'.$row['date_shipping'].'</div></td>
<td><div class="dost1">'.stripslashes($row['delivery']).'</div></td>
<td><div class="num1">'.$row['turn'].'</div></td>
<td><div class="num1">'.$row['number'].'</div></td>
<td><div class="kom1">'.stripslashes($row['other']).'</div></td>
<td><div class="pok1">'.$row['date'].'</div></td>
<td><div class="pok1">'.$row['editor'].'</div></td>';
}
exit();}
?>
</table>
</div>
</div>
</body>
</html>
Проблема в том, что поиск по английским символам и числам проходит, а вот по русским пусто