Esto sucede porque realizamos algún paso equivocadamente en el momento aquel, sobre todo porque no nos fijamos en la codificación los archivos y la base de datos.
Aclaro que este tutorial solo es para arreglar caracteres de los temas, foros, post, nombres de usuarios, firmas, etc... en si solo los datos almacenados en la base de datos.
Si este problema te sucede luego de instalar un MOD, o modificar un archivo de idioma, puedes fijarte en este documento sobre Dudas frecuentes en phpBB3, en el que se explica como solucionarlo.
Y sin más preámbulos vamos a la solución.
Esta consiste en generar unas consultas SQL mediante phpMyAdmin para reemplazar estos caracteres extraños por las letras con los acentos, las ñ y algunos caracteres especiales.
Así que abrimos nuestra base de datos mediante phpMyAdmin (esto en el caso de MySQL), o si usamos otro tipo de base de datos, entonces con su gestor favorito.
Primero que todo y como siempre, creamos una backup de la base de datos por si surge algun inconveniente.
Aca estoy poniendo los ejemplo con el prefijo "phpbb_" que es el mas usado y el que trae por defecto phpBB en su instalación, pero si usan otro deberan cambiarlo o sino, las consultas mostraran error.
Ejecutamos por partes, las siguiente consultas (también se puede ejecutar todas juntas pero lo hare de esta manera, para explicar mejor).
Nombres de los foros y subforos (Para estos tendremos que actualizar los registros de la tabla phpbb_forums):
Código: Seleccionar todo
UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã','í');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');
Código: Seleccionar todo
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã','í');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');
Código: Seleccionar todo
UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã','í');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');
Código: Seleccionar todo
UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã','í');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');
Código: Seleccionar todo
UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã','í');
UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');
Código: Seleccionar todo
UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã','í');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');
Código: Seleccionar todo
UPDATE phpbb_users SET username = replace(username,'á','á');
UPDATE phpbb_users SET username = replace(username,'é','é');
UPDATE phpbb_users SET username = replace(username,'Ã','í');
UPDATE phpbb_users SET username = replace(username,'ó','ó');
UPDATE phpbb_users SET username = replace(username,'ú','ú');
UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
UPDATE phpbb_users SET username = replace(username,'¿','¿');
UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');
Estas consultas convertiran los caracteres á , é , í , ó , ú , ñ , ¿ lo que significa que no convierten otros caractedes especiales como el º o vocales con acentos en MAYUSCULAS (É , Ú , Ó), así que deberan crear sus propias consultas para esto, explico:
Para convertIr otros caracteres que no estan acá, de la siguiente manera:
UPDATE TABLA_DE_PHPBB SET CAMPO_TABLA = replace( CAMPO_TABLA, 'CARACTER_EXTRAÑO' , 'CARACTER_CORRECTO' );
TABLA_DE_PHPBB, Tabla en la cual realizaremos la consulta, eje = phpbb_posts,
CAMPO_TABLA, campo en el cual se encuentra almanecenado el caracter extraño, eje = post_text,
CARACTER_EXTRAÑO, caracter que queremos convertir, eje = ´ => caracter extraño que representa la Á,
CARACTER_CORRECTO, caracter correcto por que queremos reemplazar el extraño, eje = Á,
Entonces si queremos crear una consulta con el ejemplo anterior que puse quedaria de la siguiete manera:
UPDATE phpbb_posts SET post_text = replace( post_text , '´' , 'Á' );
Y lo que haria, seria reemplazar todos los caracteres estraños que representan la á mayuscula por "Á".
Espero haberme hecho entender y que esta guía les sea de utilidad, cualquier duda, pueden preguntar.
Agrego unas cuantas lineas mas que HuanManwe nos ha compartido para hacer mas amplia la solucion.
Código: Seleccionar todo
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ƒÂ','');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'á','á');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'é','é');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã-','í');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ó','ó');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ú','ú');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ñ','ñ');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¿','¿');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'´','Á');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'É','É');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ó','Ó');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ú','Ú');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¡','¡');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ñ','Ñ');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'À','À');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'È','È');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'è','è');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã’','Ò');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ò','ò');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã','í');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Â','Í');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ƒÂ','');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'á','á');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'é','é');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ã-','í');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ó','ó');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ú','ú');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ñ','ñ');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¿','¿');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'´','Á');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'É','É');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ó','Ó');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ú','Ú');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¡','¡');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ñ','Ñ');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'À','À');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'È','È');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'è','è');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ã’','Ò');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ò','ò');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Â','Í');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ƒÂ','');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'á','á');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'é','é');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã-','í');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ó','ó');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ú','ú');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ñ','ñ');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¿','¿');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'´','Á');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'É','É');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ó','Ó');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ú','Ú');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¡','¡');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ñ','Ñ');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'À','À');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'È','È');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'è','è');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã’','Ò');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ò','ò');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã','í');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ƒÂ','');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'á','á');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'é','é');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã-','í');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ú','ú');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ñ','ñ');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¿','¿');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'´','Á');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'É','É');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ó','Ó');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ú','Ú');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¡','¡');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ñ','Ñ');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'À','À');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'È','È');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'è','è');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã’','Ò');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ò','ò');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã','í');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ƒÂ','');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã-','í');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'´','Á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'É','É');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ó','Ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ú','Ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¡','¡');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'À','À');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'È','È');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'è','è');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã’','Ò');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ò','ò');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã','í');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ƒÂ','');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã-','í');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'´','Á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'É','É');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ó','Ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ú','Ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¡','¡');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'À','À');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'È','È');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'è','è');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã’','Ò');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ò','ò');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã','í');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ƒÂ','');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'á','á');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'é','é');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã-','í');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ó','ó');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ú','ú');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ñ','ñ');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¿','¿');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'´','Á');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'É','É');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ó','Ó');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ú','Ú');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¡','¡');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'À','À');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'È','È');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'è','è');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã’','Ò');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ò','ò');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã','í');
UPDATE phpbb_groups SET group_name = replace(group_name,'ƒÂ','');
UPDATE phpbb_groups SET group_name = replace(group_name,'á','á');
UPDATE phpbb_groups SET group_name = replace(group_name,'é','é');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ã-','í');
UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'ú','ú');
UPDATE phpbb_groups SET group_name = replace(group_name,'ñ','ñ');
UPDATE phpbb_groups SET group_name = replace(group_name,'¿','¿');
UPDATE phpbb_groups SET group_name = replace(group_name,'´','Á');
UPDATE phpbb_groups SET group_name = replace(group_name,'É','É');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ó','Ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ú','Ú');
UPDATE phpbb_groups SET group_name = replace(group_name,'¡','¡');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ñ','Ñ');
UPDATE phpbb_groups SET group_name = replace(group_name,'À','À');
UPDATE phpbb_groups SET group_name = replace(group_name,'È','È');
UPDATE phpbb_groups SET group_name = replace(group_name,'è','è');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ã’','Ò');
UPDATE phpbb_groups SET group_name = replace(group_name,'ò','ò');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ã','í');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ƒÂ','');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'á','á');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'é','é');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã-','í');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ú','ú');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ñ','ñ');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'¿','¿');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'´','Á');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'É','É');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ó','Ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ú','Ú');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'¡','¡');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ñ','Ñ');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'À','À');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'È','È');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'è','è');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã’','Ò');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ò','ò');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã','í');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ƒÂ','');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'á','á');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'é','é');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã-','í');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ó','ó');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ú','ú');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ñ','ñ');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¿','¿');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'´','Á');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'É','É');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ó','Ó');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ú','Ú');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¡','¡');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ñ','Ñ');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'À','À');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'È','È');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'è','è');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã’','Ò');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ò','ò');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã','í');
UPDATE phpbb_log SET log_data = replace(log_data,'ƒÂ','');
UPDATE phpbb_log SET log_data = replace(log_data,'á','á');
UPDATE phpbb_log SET log_data = replace(log_data,'é','é');
UPDATE phpbb_log SET log_data = replace(log_data,'Ã-','í');
UPDATE phpbb_log SET log_data = replace(log_data,'ó','ó');
UPDATE phpbb_log SET log_data = replace(log_data,'ú','ú');
UPDATE phpbb_log SET log_data = replace(log_data,'ñ','ñ');
UPDATE phpbb_log SET log_data = replace(log_data,'¿','¿');
UPDATE phpbb_log SET log_data = replace(log_data,'´','Á');
UPDATE phpbb_log SET log_data = replace(log_data,'É','É');
UPDATE phpbb_log SET log_data = replace(log_data,'Ó','Ó');
UPDATE phpbb_log SET log_data = replace(log_data,'Ú','Ú');
UPDATE phpbb_log SET log_data = replace(log_data,'¡','¡');
UPDATE phpbb_log SET log_data = replace(log_data,'Ñ','Ñ');
UPDATE phpbb_log SET log_data = replace(log_data,'À','À');
UPDATE phpbb_log SET log_data = replace(log_data,'È','È');
UPDATE phpbb_log SET log_data = replace(log_data,'è','è');
UPDATE phpbb_log SET log_data = replace(log_data,'Ã’','Ò');
UPDATE phpbb_log SET log_data = replace(log_data,'ò','ò');
UPDATE phpbb_log SET log_data = replace(log_data,'Ã','í');
UPDATE phpbb_moderator_cache SET username = replace(username,'ƒÂ','');
UPDATE phpbb_moderator_cache SET username = replace(username,'á','á');
UPDATE phpbb_moderator_cache SET username = replace(username,'é','é');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ã-','í');
UPDATE phpbb_moderator_cache SET username = replace(username,'ó','ó');
UPDATE phpbb_moderator_cache SET username = replace(username,'ú','ú');
UPDATE phpbb_moderator_cache SET username = replace(username,'ñ','ñ');
UPDATE phpbb_moderator_cache SET username = replace(username,'¿','¿');
UPDATE phpbb_moderator_cache SET username = replace(username,'´','Á');
UPDATE phpbb_moderator_cache SET username = replace(username,'É','É');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ó','Ó');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ú','Ú');
UPDATE phpbb_moderator_cache SET username = replace(username,'¡','¡');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ñ','Ñ');
UPDATE phpbb_moderator_cache SET username = replace(username,'À','À');
UPDATE phpbb_moderator_cache SET username = replace(username,'È','È');
UPDATE phpbb_moderator_cache SET username = replace(username,'è','è');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ã’','Ò');
UPDATE phpbb_moderator_cache SET username = replace(username,'ò','ò');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ã','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ƒÂ','');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'é','é');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã-','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ó','ó');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ú','ú');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ñ','ñ');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¿','¿');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'´','Á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ó','Ó');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ú','Ú');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¡','¡');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ñ','Ñ');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'À','À');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'È','È');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'è','è');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã’','Ò');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ò','ò');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'€','€');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ƒÂ','');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã-','í');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'´','Á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'É','É');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ó','Ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ú','Ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'©','©');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¡','¡');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ñ','Ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'À','À');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'È','È');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'è','è');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã’','Ò');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ò','ò');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã','í');
UPDATE phpbb_posts SET post_text = replace(post_text,'ƒÂ','');
UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã-','í');
UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'í±','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');
UPDATE phpbb_posts SET post_text = replace(post_text,'´','Á');
UPDATE phpbb_posts SET post_text = replace(post_text,'É','É');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ó','Ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ú','Ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'©','©');
UPDATE phpbb_posts SET post_text = replace(post_text,'¡','¡');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ñ','Ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'À','À');
UPDATE phpbb_posts SET post_text = replace(post_text,'È','È');
UPDATE phpbb_posts SET post_text = replace(post_text,'è','è');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã’','Ò');
UPDATE phpbb_posts SET post_text = replace(post_text,'ò','ò');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã','í');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ƒÂ','');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'á','á');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'é','é');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã-','í');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ó','ó');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ú','ú');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ñ','ñ');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¿','¿');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'´','Á');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'É','É');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ó','Ó');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ú','Ú');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¡','¡');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ñ','Ñ');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'À','À');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'È','È');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'è','è');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã’','Ò');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ò','ò');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã','í');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ƒÂ','');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'á','á');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'é','é');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã-','í');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ó','ó');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ú','ú');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ñ','ñ');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¿','¿');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'´','Á');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'É','É');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ó','Ó');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ú','Ú');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¡','¡');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ñ','Ñ');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'À','À');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'È','È');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'è','è');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã’','Ò');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ò','ò');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã','í');
UPDATE phpbb_reports SET report_text = replace(report_text,'ƒÂ','');
UPDATE phpbb_reports SET report_text = replace(report_text,'á','á');
UPDATE phpbb_reports SET report_text = replace(report_text,'é','é');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ã-','í');
UPDATE phpbb_reports SET report_text = replace(report_text,'ó','ó');
UPDATE phpbb_reports SET report_text = replace(report_text,'ú','ú');
UPDATE phpbb_reports SET report_text = replace(report_text,'ñ','ñ');
UPDATE phpbb_reports SET report_text = replace(report_text,'¿','¿');
UPDATE phpbb_reports SET report_text = replace(report_text,'´','Á');
UPDATE phpbb_reports SET report_text = replace(report_text,'É','É');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ó','Ó');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ú','Ú');
UPDATE phpbb_reports SET report_text = replace(report_text,'¡','¡');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ñ','Ñ');
UPDATE phpbb_reports SET report_text = replace(report_text,'À','À');
UPDATE phpbb_reports SET report_text = replace(report_text,'È','È');
UPDATE phpbb_reports SET report_text = replace(report_text,'è','è');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ã’','Ò');
UPDATE phpbb_reports SET report_text = replace(report_text,'ò','ò');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ã','í');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ƒÂ','');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'á','á');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'é','é');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã-','í');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ó','ó');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ú','ú');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ñ','ñ');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¿','¿');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'´','Á');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'É','É');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ó','Ó');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ú','Ú');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¡','¡');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ñ','Ñ');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'À','À');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'È','È');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'è','è');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã’','Ò');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ò','ò');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã','í');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ƒÂ','');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã-','í');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'´','Á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'É','É');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ó','Ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ú','Ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'©','©');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¡','¡');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'À','À');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'È','È');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'è','è');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã’','Ò');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ò','ò');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã','í');
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,'Ã','í');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ƒÂ','');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'á','á');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'é','é');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã-','í');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ó','ó');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ú','ú');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ñ','ñ');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¿','¿');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'´','Á');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'É','É');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ó','Ó');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ú','Ú');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¡','¡');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'À','À');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'È','È');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'è','è');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã’','Ò');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ò','ò');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã','í');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ƒÂ','');
UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã-','í');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');
UPDATE phpbb_users SET user_sig = replace(user_sig,'´','Á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'É','É');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ó','Ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ú','Ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¡','¡');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ñ','Ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'À','À');
UPDATE phpbb_users SET user_sig = replace(user_sig,'È','È');
UPDATE phpbb_users SET user_sig = replace(user_sig,'è','è');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã’','Ò');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ò','ò');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã','í');
UPDATE phpbb_users SET username = replace(username,'ƒÂ','');
UPDATE phpbb_users SET username = replace(username,'á','á');
UPDATE phpbb_users SET username = replace(username,'é','é');
UPDATE phpbb_users SET username = replace(username,'Ã-','í');
UPDATE phpbb_users SET username = replace(username,'ó','ó');
UPDATE phpbb_users SET username = replace(username,'ú','ú');
UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
UPDATE phpbb_users SET username = replace(username,'¿','¿');
UPDATE phpbb_users SET username = replace(username,'ª','ª');
UPDATE phpbb_users SET username = replace(username,'´','Á');
UPDATE phpbb_users SET username = replace(username,'É','É');
UPDATE phpbb_users SET username = replace(username,'Ó','Ó');
UPDATE phpbb_users SET username = replace(username,'Ú','Ú');
UPDATE phpbb_users SET username = replace(username,'¡','¡');
UPDATE phpbb_users SET username = replace(username,'Ñ','Ñ');
UPDATE phpbb_users SET username = replace(username,'À','À');
UPDATE phpbb_users SET username = replace(username,'È','È');
UPDATE phpbb_users SET username = replace(username,'è','è');
UPDATE phpbb_users SET username = replace(username,'Ã’','Ò');
UPDATE phpbb_users SET username = replace(username,'ò','ò');
UPDATE phpbb_users SET username = replace(username,'Ã','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ƒÂ','');
UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã-','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');
UPDATE phpbb_users SET username_clean = replace(username_clean,'´','Á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'À','Á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'‰','É');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ó','Ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ú','Ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¡','¡');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ñ','Ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'À','À');
UPDATE phpbb_users SET username_clean = replace(username_clean,'È','È');
UPDATE phpbb_users SET username_clean = replace(username_clean,'è','è');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã’','Ò');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ò','ò');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã','í');
UPDATE phpbb_styles SET style_copyright = replace(style_copyright,'©','©');
Código: Seleccionar todo
UPDATE phpbb_users SET user_from = replace(user_from,'ƒÂ','');
UPDATE phpbb_users SET user_from = replace(user_from,'á','á');
UPDATE phpbb_users SET user_from = replace(user_from,'é','é');
UPDATE phpbb_users SET user_from = replace(user_from,'Ã-','í');
UPDATE phpbb_users SET user_from = replace(user_from,'ó','ó');
UPDATE phpbb_users SET user_from = replace(user_from,'ú','ú');
UPDATE phpbb_users SET user_from = replace(user_from,'ñ','ñ');
UPDATE phpbb_users SET user_from = replace(user_from,'¿','¿');
UPDATE phpbb_users SET user_from = replace(user_from,'´','Á');
UPDATE phpbb_users SET user_from = replace(user_from,'À','Á');
UPDATE phpbb_users SET user_from = replace(user_from,'‰','É');
UPDATE phpbb_users SET user_from = replace(user_from,'Ó','Ó');
UPDATE phpbb_users SET user_from = replace(user_from,'Ú','Ú');
UPDATE phpbb_users SET user_from = replace(user_from,'¡','¡');
UPDATE phpbb_users SET user_from = replace(user_from,'Ñ','Ñ');
UPDATE phpbb_users SET user_from = replace(user_from,'À','À');
UPDATE phpbb_users SET user_from = replace(user_from,'È','È');
UPDATE phpbb_users SET user_from = replace(user_from,'è','è');
UPDATE phpbb_users SET user_from = replace(user_from,'Ã’','Ò');
UPDATE phpbb_users SET user_from = replace(user_from,'ò','ò');
UPDATE phpbb_users SET user_from = replace(user_from,'Ã','í');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ƒÂ','');
UPDATE phpbb_users SET user_occ = replace(user_occ,'á','á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'é','é');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ã-','í');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ó','ó');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ú','ú');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ñ','ñ');
UPDATE phpbb_users SET user_occ = replace(user_occ,'¿','¿');
UPDATE phpbb_users SET user_occ = replace(user_occ,'´','Á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'À','Á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'‰','É');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ó','Ó');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ú','Ú');
UPDATE phpbb_users SET user_occ = replace(user_occ,'¡','¡');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ñ','Ñ');
UPDATE phpbb_users SET user_occ = replace(user_occ,'À','À');
UPDATE phpbb_users SET user_occ = replace(user_occ,'È','È');
UPDATE phpbb_users SET user_occ = replace(user_occ,'è','è');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ã’','Ò');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ò','ò');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ã','í');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ƒÂ','');
UPDATE phpbb_users SET user_interests = replace(user_interests,'á','á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'é','é');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ã-','í');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ó','ó');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ú','ú');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ñ','ñ');
UPDATE phpbb_users SET user_interests = replace(user_interests,'¿','¿');
UPDATE phpbb_users SET user_interests = replace(user_interests,'´','Á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'À','Á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'‰','É');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ó','Ó');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ú','Ú');
UPDATE phpbb_users SET user_interests = replace(user_interests,'¡','¡');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ñ','Ñ');
UPDATE phpbb_users SET user_interests = replace(user_interests,'À','À');
UPDATE phpbb_users SET user_interests = replace(user_interests,'È','È');
UPDATE phpbb_users SET user_interests = replace(user_interests,'è','è');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ã’','Ò');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ò','ò');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ã','í');
EDITADO por leviatan21: añado adjunto un charset.zip con un script que se encargara de "arreglar" los caracteres extraños que hallan en nuestro foro.. EDITADO por HuanManwe: actualizado el archivo txt adjunto con todo el listado al día 27 de diciembre del 2010 con el aporte de karbiko: http://www.phpbb-es.com/foro/mensaje168580.html#p168570. Instrucciones :
Descargar el adjunto, descomprimir y subir al servidor, para ejecutarlo se debe estar identificado en el foro como administrador, preferentemente fundador.
Una vez en tu servidor, abrir una ventana y apuntar el navegador a esta dirección :
Código: Seleccionar todo
http://URL_AL_RAIZ_DEL_FORO/charset.php