yeniaykarama 19.02.2007, 00:30
benimde o şekil bir karakter sorunum olmuştu aradım taradım şunu buldum bütüm mesaj içeriklerim düzeldi şimdi sorun yok:
[syntax="sql"]UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ı', 'i');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'Ş', 's');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ş', 's');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ğ', 'g');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ö', 'ö');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ü', 'ü');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ç', 'c');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'Ãœ', 'ü');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '?', 'ü');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'Ç', 'c');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '>', '>');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'Ö', 'ö');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '’', '`');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ý;', 'i');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'þ', 's');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'ð', 'g');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '?nce', 'önce');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '?aresi', 'caresi');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'd?n?st?r', 'dönüstür');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 's?r?c?', 'sürücü');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'g?z', 'göz');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'b?y?k', 'büyük');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'L?tfen', 'Lütfen');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'l?tfen', 'Lütfen');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'T?rk?e', 'Türkce');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 't?rk?e', 'Türkce');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '??z?l', 'cözül');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, '?ye', 'üye');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 't?m', 'tüm');
UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'Ã', 'Ş'); [/syntax]