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 '%Ä%';