Ajax Arama türkçe karakter sorunu.(çözüldü)

[Lakırtı]

Merhaba, ne yaptıysam ajax aramasında türkçe karakter sorununu çözemedim. Çok araştırdım ben gibi excell import export modülünü kullananlarda hep bu sorun mevcut. Bu sorunu çözebilen yada nasıl çözebileceğimizi bilen biri var mı acaba?

Çözüm:

Çözümünü ben şu şekilde buldum.
(not bu işlemi excell den her import yaptığınız da tekrar gerçekleştirmeniz gerekmektedir.)

Phpmyadmin'e giriyoruz, sql sorgusu olarak aşağıdaki komutların hepsini kopyala yapıştır yapıp komutları gönderin. Sitenize girip test edin, 3 sitemde başarılı oldum, sonucu paylaşırsanız sevinirim.

PHP Kod:

1 2 3 4 5 6 7 8 9 10

UPDATE product_description SET name = replace(name, "ü", "ü"); UPDATE product_description SET name = replace(name, "&Uuml,", "Ü"); UPDATE product_description SET name = replace(name, "Ş", "Ş"); UPDATE product_description SET name = replace(name, "ş", "ş"); UPDATE product_description SET name = replace(name, "Ö", "Ö"); UPDATE product_description SET name = replace(name, "ö", "ö"); UPDATE product_description SET name = replace(name, "Ç", "Ç"); UPDATE product_description SET name = replace(name, "ç", "ç"); UPDATE product_description SET name = replace(name, "Ğ", "Ğ"); UPDATE product_description SET name = replace(name, "ğ", "ğ"); UPDATE product_description SET name = replace(name, "İ", "İ"); UPDATE product_description SET name = replace(name, "ı", "ı"); UPDATE product_description SET description = replace(description, "ü", "ü"); UPDATE product_description SET description = replace(description, "&Uuml,", "Ü"); UPDATE product_description SET description = replace(description, "Ş", "Ş"); UPDATE product_description SET description = replace(description, "ş", "ş"); UPDATE product_description SET description = replace(description, "Ö", "Ö"); UPDATE product_description SET description = replace(description, "ö", "ö"); UPDATE product_description SET description = replace(description, "Ç", "Ç"); UPDATE product_description SET description = replace(description, "ç", "ç"); UPDATE product_description SET description = replace(description, "Ğ", "Ğ"); UPDATE product_description SET description = replace(description, "ğ", "ğ"); UPDATE product_description SET description = replace(description, "İ", "İ"); UPDATE product_description SET description = replace(description, "ı", "ı"); UPDATE category_description SET name = replace(name, "ü", "ü"); UPDATE category_description SET name = replace(name, "&Uuml,", "Ü"); UPDATE category_description SET name = replace(name, "Ş", "Ş"); UPDATE category_description SET name = replace(name, "ş", "ş"); UPDATE category_description SET name = replace(name, "Ö", "Ö"); UPDATE category_description SET name = replace(name, "ö", "ö"); UPDATE category_description SET name = replace(name, "Ç", "Ç"); UPDATE category_description SET name = replace(name, "ç", "ç"); UPDATE category_description SET name = replace(name, "Ğ", "Ğ"); UPDATE category_description SET name = replace(name, "ğ", "ğ"); UPDATE category_description SET name = replace(name, "İ", "İ"); UPDATE category_description SET name = replace(name, "ı", "ı"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "ü", "ü"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "&Uuml,", "Ü"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "Ş", "Ş"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "ş", "ş"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "Ö", "Ö"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "ö", "ö"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "Ç", "Ç"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "ç", "ç"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "Ğ", "Ğ"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "ğ", "ğ"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "İ", "İ"); UPDATE product_description SET meta_keywords= replace(meta_keywords, "ı", "ı"); UPDATE product_description SET meta_description= replace(meta_description, "ü", "ü"); UPDATE product_description SET meta_description= replace(meta_description, "&Uuml,", "Ü"); UPDATE product_description SET meta_description= replace(meta_description, "Ş", "Ş"); UPDATE product_description SET meta_description= replace(meta_description, "ş", "ş"); UPDATE product_description SET meta_description= replace(meta_description, "Ö", "Ö"); UPDATE product_description SET meta_description= replace(meta_description, "ö", "ö"); UPDATE product_description SET meta_description= replace(meta_description, "Ç", "Ç"); UPDATE product_description SET meta_description= replace(meta_description, "ç", "ç"); UPDATE product_description SET meta_description= replace(meta_description, "Ğ", "Ğ"); UPDATE product_description SET meta_description= replace(meta_description, "ğ", "ğ"); UPDATE product_description SET meta_description= replace(meta_description, "İ", "İ"); UPDATE product_description SET meta_description= replace(meta_description, "ı", "ı");

---