Recordad que para pedir soporte alguno, debéis facilitar los datos de soporte oportunos por favor, mirad aquí y leer las Normas generales del foro, esto nos servirá de ayuda para dar el mejor soporte..

Gracias.

La Administración de phpBB España.

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

Guías phpBB 3.1 3.2 3.3


Cerrado
Avatar de Usuario
Alorse
Ex Staff
Mensajes: 5144
Registrado: 22 Mar 2008, 02:14
Género:
Edad: 36

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

#1

Mensaje por Alorse »

Esta es una duda más que común y que tal vez a todos nos ha llegado a suceder alguna vez si es que hemos llegado a migrar una base de datos de un gestor a otro o haber migrado de phpBB2 a phpBB3 o simplemente luego de trasladar nuestro foro a otro servidor.

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 algún inconveniente.

Aquí 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 deberán cambiarlo o sino, las consultas mostraran error.

Ejecutamos por partes, las siguiente consultas (también se puede ejecutar todas juntas pero lo haré 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,'¿','¿');
Descripción de los foros y subforos:

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,'¿','¿');
Titulos de los Temas (Para estos tendremos que actualizar los registros de la tabla phpbb_topics):

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,'¿','¿');
Asuntos de los mensajes (Para estos tendremos que actualizar los registros de la tabla phpbb_posts):

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,'¿','¿');
Texto de los mensajes (Si tu foro es muy grande y tiene demasiados mensajes, esta consulta puede tardar mas en realizarse, así que tengamos paciencia):

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,'¿','¿');
Firmas de los usuarios (Para estos tendremos que actualizar los registros de la tabla phpbb_users):

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,'¿','¿');
Nicks de los usuarios (Algunos usuarios usan caracteres especiales o acentos en sus Nicks, así que también es necesario actualizar estos campos).

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 convertirán los caracteres á , é , í , ó , ú , ñ , ¿ lo que significa que no convierten otros caracteres especiales como el º o vocales con acentos en MAYÚSCULAS (É , Ú , Ó), así que deberán crear sus propias consultas para esto, explico:

Para convertir otros caracteres que no están 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 almacenado el carácter extraño, eje = post_text,
CARÁCTER_EXTRAÑO, carácter que queremos convertir, eje = ´ => carácter extraño que representa la Á,
CARÁCTER_CORRECTO, carácter correcto por que queremos reemplazar el extraño, eje = Á,

Entonces si queremos crear una consulta con el ejemplo anterior que puse quedaría de la siguiente manera:

UPDATE phpbb_posts SET post_text = replace( post_text , '´' , 'Á' );

Y lo que haría, seria reemplazar todos los caracteres extraños que representan la á mayúscula 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 solución.

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,'©','©');
Otra mas para la tabla phpbb_users - campos: user_from (ubicación), user_occ (ocupación), user_interests (intereses)

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,'Ã','í');
Saludos.

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.
Descargar archivo charset por leviatan21.
Más información en este tema.

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
Descargar archivo Solución caracteres extraños por HuanManwe.
Más información en este tema.


Instrucciones

Descargar el archivo 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 :
http://URL_AL_RAIZ_DEL_FORO/charset.php

Puede resultar lento, y se debe ejecutar tantas veces como sea necesario, hasta que en la pantalla sólo aparezca la palabra FIN
Adjuntos
solucion_caracteres_extraños_2010_12_27.zip
Solucion caracteres extraños por HuanManwe
(3.04 KiB) Descargado 317 veces
charset.zip
charset por leviatan21
(2.73 KiB) Descargado 329 veces

Cerrado

Volver a “📝 Guías sobre phpBB”