mysql de türkçe kayıtlı alanlarda arama yapmak
function tr_strtolower($metin) {
$metin = strtr($metin, "IĞÜŞİÖÇ", "ığüşiöç");
return strtolower($metin);
}
SELECT * from ogrenciler where replace(replace(replace(replace(replace(replace(ki si_adi,"ş","s"),"ç","c"),"ğ","g")
,"ö","o"),"ı","i"),"ü","u")="'.tr_strtolower("Şaba n AKÇAYIR").'"';
__________________ |