From: ilyas OZGOREN (iozgoren@yahoo.com)
Date: Tue 24 Jul 2007 - 12:18:39 EEST
Ş ve İ gibi türkce karakter ile sorgu gonderince asagidaki 1. kodda hata veriyor
$d1="Ş0001";
$mysqli = new mysqli('localhost', 'root', '','ilko');
$query = "select * from table where numara like '".$d1."%' group by ad";
$result = $mysqli->query($query);
if ( !$result )
{
echo '<div>Error: ', $mysqli->error, '</br>Query: ', htmlentities($query), "</div>\n";
die();
}
$dr = $result->fetch_array(MYSQLI_ASSOC);
kodunda
hata mesaji olarak
Error: Illegal mix of collations (latin5_turkish_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'
veriyor.
Ancak
aynı sorgu
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
mysql_query("SET COLLATION_CONNECTION = 'utf8'");
$sql2="select * from table where numara like '".$d1."%' group by ad";
//echo $sql2;
$sel2=mysql_query($sql2);
$ra=mysql_fetch_row ($sel2);
olarak yazilinca canavar gibi çalışıyor.
1. ci sorguya
@$result = $mysqli->query("SET NAMES 'utf8'");
@$result = $mysqli->query("SET CHARACTER SET 'utf8'");
@$result = $mysqli->query("SET COLLATION_CONNECTION = 'utf8'");
satirlarini ekleyince yine ayni hata geliyor
sorun nedir acaba???
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/
_______________________________________________
Linux-programlama mailing list
Linux-programlama@liste.linux.org.tr
http://liste.linux.org.tr/mailman/listinfo/linux-programlama