Re: Solución Caracteres Extraños al convertir, migrar, trasladar
Publicado: 24 Nov 2010, 20:09
IMPRESIONANTE trabajo, si esta al 100% va a la Biblioteca ya! 
phpBB España Oficial, Soporte Internacional Oficial del sistema de foros phpBB en Español, extensiones, estilos, traducciones, guías, tutoriales, videos, redes sociales, webmaster.
https://www.phpbb-es.com/foro/
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,'í','í');