sorunu buldum dbyi taşırken türkçe karakterleri bozuk kaydetmiş düzeltme kodunu buldum ancak bu seferde aşağıdaki hatayı veriyor

UPDATE forum SET title = REPLACE( title, 'þ', 'ş' ) WHERE title LIKE '%þ%';



MySQL çıktısı:  

#1270 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_unicode_ci,COERCIBLE), (utf8_unicode_ci,COERCIBLE) for operation 'replace'
Düzeltme kodu


UPDATE forum SET title = REPLACE (title, 'þ', 'ş' ) WHERE title LIKE '%þ%';
UPDATE forum SET title = REPLACE (title, 'Ãz', 'Ş' ) WHERE title LIKE '%Ãz%';
UPDATE forum SET title = REPLACE (title, 'Ç', 'Ç' ) WHERE title LIKE '%Ç%';
UPDATE forum SET title = REPLACE (title, 'ç', 'ç' ) WHERE title LIKE '%ç%';
UPDATE forum SET title = REPLACE (title, 'Ã?', 'Ö' ) WHERE title LIKE '%Ã?%';
UPDATE forum SET title = REPLACE (title, 'Ö', 'Ö' ) WHERE title LIKE '%Ö%';
UPDATE forum SET title = REPLACE (title, 'ö', 'ö' ) WHERE title LIKE '%ö%';
UPDATE forum SET title = REPLACE (title, 'ü', 'ü' ) WHERE title LIKE '%ü%';
UPDATE forum SET title = REPLACE (title, 'ð', 'ğ' ) WHERE title LIKE '%ð%';
UPDATE forum SET title = REPLACE (title, 'ý', 'ı' ) WHERE title LIKE '%ý%';
UPDATE forum SET title = REPLACE (title, 'Ý', 'İ' ) WHERE title LIKE '%Ý%';
UPDATE forum SET title = REPLACE (title, 'Ü', 'Ü' ) WHERE title LIKE '%Ü%';
UPDATE forum SET title = REPLACE (title, 'Ğ', 'Ğ' ) WHERE title LIKE '%Ğ%';