Wp’de türkçe karakter hatası verirse, sql replace kodları.

 

 

UPDATE wp_posts SET post_title = replace(post_title, ‘ö’, ‘ö’);UPDATE wp_posts SET post_title = replace(post_title, ‘ÄŸ’, ‘ğ’);UPDATE wp_posts SET post_title = replace(post_title, ‘Äz’, ‘Ğ’);UPDATE wp_posts SET post_title = replace(post_title, ‘ü’, ‘ü’);UPDATE wp_posts SET post_title = replace(post_title, ‘Ç’, ‘Ç’);UPDATE wp_posts SET post_title = replace(post_title, ‘ç’, ‘ç’);UPDATE wp_posts SET post_title = replace(post_title, ‘Åž’, ‘Ş’);UPDATE wp_posts SET post_title = replace(post_title, ‘ÅŸ’, ‘ş’);UPDATE wp_posts SET post_title = replace(post_title, ‘Ö’, ‘Ö’);UPDATE wp_posts SET post_title = replace(post_title, ‘ı’, ‘ı’);UPDATE wp_posts SET post_title = replace(post_title, ‘Ä°’, ‘İ’);UPDATE wp_posts SET post_title = replace(post_title, ‘Ãœ’, ‘Ü’);
UPDATE wp_terms SET name = replace(name, ‘ö’, ‘ö’);UPDATE wp_terms SET name = replace(name, ‘ÄŸ’, ‘ğ’);UPDATE wp_terms SET name = replace(name, ‘Äz’, ‘Ğ’);UPDATE wp_terms SET name = replace(name, ‘ü’, ‘ü’);UPDATE wp_terms SET name = replace(name, ‘Ç’, ‘Ç’);UPDATE wp_terms SET name = replace(name, ‘ç’, ‘ç’);UPDATE wp_terms SET name = replace(name, ‘Åž’, ‘Ş’);UPDATE wp_terms SET name = replace(name, ‘ÅŸ’, ‘ş’);UPDATE wp_terms SET name = replace(name, ‘Ö’, ‘Ö’);UPDATE wp_terms SET name = replace(name, ‘ı’, ‘ı’);UPDATE wp_terms SET name = replace(name, ‘Ä°’, ‘İ’);UPDATE wp_terms SET name = replace(name, ‘Ãœ’, ‘Ü’);