Solución Caracteres Extraños al convertir, migrar, trasladarTema Solucionado

[ThE KuKa]

IMPRESIONANTE trabajo, si esta al 100% va a la Biblioteca ya!

[HuanManwe]

como poder ponerse en biblioteca se puede poner... pero sigo con la sensación de que todos esos problemas podrían arreglarse dando con la tecla exacta en el collate de las tablas. Aunque para quienes no puedan empezar de cero y se hayan encontrado una base de datos ya con ese problema podría ser una solución de emergencia.

[HuanManwe]

Edité mi mensaje más "completo" para añadir estas líneas para phpbb_topics SET topic_last_post_subject:

Código: Seleccionar todo

UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'','');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'á','á');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'é','é');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í','í');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ó','ó');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ú','ú');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ñ','ñ');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'¿','¿');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Á','Á');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'É','É');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ó','Ó');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'íš','Ú');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'©','©');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'¡','¡');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'À','À');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'íˆ','È');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'È','è');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í’','Ò');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í²','ò');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í','í');

[Alorse]

Se ha agregado al post principal (gracias HuanManwe) un script que ha creado nuestro compañero leviatan21, para que no sea tan tedioso ejecutar consulta por consulta, con dicho script solo es ejecutarlo desde la web y este se encargara de "arreglar" los caracteres extraños que haya en nuestro foro.

Gracias leviatan21.