From: Ismail ASCI (ismail.asci@gmail.com)
Date: Tue 24 Jul 2007 - 12:26:38 EEST
Merhaba,
Kullandiginiz araclarin (php, mysql, apache vs.) karakter
kodlamalarinin ayni oldugına emin olursaniz sorun kalmayacaktir.
Ayrica UTF-8 kullanmanizi tavsiye ederim.
On 7/24/07, ilyas OZGOREN <iozgoren@yahoo.com> wrote:
>
> Ş 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! Mail is the world's favourite email. Don't settle for less, sign up
> for your free account today.
> _______________________________________________
> Linux-programlama mailing list
> Linux-programlama@liste.linux.org.tr
> http://liste.linux.org.tr/mailman/listinfo/linux-programlama
>
>
-- Ismail ASCI-----BEGIN PGP PUBLIC KEY BLOCK----- Version: GnuPG v1.4.2.2 (GNU/Linux)
iFQEIBECABQFAkRIDJMNHQBiYWNrdXAgY29weQAKCRBgYvyi4RxNdcnIAJ9vweb8 vUH9m3a2aQHyAfeo0oJtlACfQiqcbHvdBtrxylRh42G2xea7gFM= =Xy4T -----END PGP PUBLIC KEY BLOCK----- _______________________________________________ Linux-programlama mailing list Linux-programlama@liste.linux.org.tr http://liste.linux.org.tr/mailman/listinfo/linux-programlama