Ticket #17487: reemplazos.php

File reemplazos.php, 8.4 KB (added by bi0xid, 2 years ago)

Replace LATIN1 -> UTF-8

Line 
1UPDATE wp_posts SET post_content = REPLACE (post_content,'á','á');
2UPDATE wp_posts SET post_title =  REPLACE (post_title,'á','á');
3UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'á','á');
4UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'á','á');
5UPDATE wp_links SET link_name =  REPLACE (link_name,'á','á');
6UPDATE wp_options SET option_value =  REPLACE (option_value,'á','á');
7UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'á','á');
8UPDATE wp_users SET display_name =  REPLACE (display_name,'á','á');
9
10UPDATE wp_posts SET post_content = REPLACE (post_content,'é','é');
11UPDATE wp_posts SET post_title =  REPLACE (post_title,'é','é');
12UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'é','é');
13UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'é','é');
14UPDATE wp_links SET link_name =  REPLACE (link_name,'é','é');
15UPDATE wp_options SET option_value =  REPLACE (option_value,'é','é');
16UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'é','é');
17UPDATE wp_users SET display_name =  REPLACE (display_name,'é','é');
18
19UPDATE wp_posts SET post_content = REPLACE (post_content,'ó','ó');
20UPDATE wp_posts SET post_title =  REPLACE (post_title,'ó','ó');
21UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'ó','ó');
22UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'ó','ó');
23UPDATE wp_links SET link_name =  REPLACE (link_name,'ó','ó');
24UPDATE wp_options SET option_value =  REPLACE (option_value,'ó','ó');
25UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'ó','ó');
26UPDATE wp_users SET display_name =  REPLACE (display_name,'ó','ó');
27
28UPDATE wp_posts SET post_content = REPLACE (post_content,'¿','¿');
29UPDATE wp_posts SET post_title =  REPLACE (post_title,'¿','¿');
30UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'¿','¿');
31UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'¿','¿');
32UPDATE wp_links SET link_name =  REPLACE (link_name,'¿','¿');
33UPDATE wp_options SET option_value =  REPLACE (option_value,'¿','¿');
34UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'¿','¿');
35UPDATE wp_users SET display_name =  REPLACE (display_name,'¿','¿');
36
37UPDATE wp_posts SET post_content = REPLACE (post_content,'ú','ú');
38UPDATE wp_posts SET post_title =  REPLACE (post_title,'ú','ú');
39UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'ú','ú');
40UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'ú','ú');
41UPDATE wp_links SET link_name =  REPLACE (link_name,'ú','ú');
42UPDATE wp_options SET option_value =  REPLACE (option_value,'ú','ú');
43UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'ú','ú');
44UPDATE wp_users SET display_name =  REPLACE (display_name,'ú','ú');
45
46UPDATE wp_posts SET post_content = REPLACE (post_content,'ñ','ñ');
47UPDATE wp_posts SET post_title =  REPLACE (post_title,'ñ','ñ');
48UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'ñ','ñ');
49UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'ñ','ñ');
50UPDATE wp_links SET link_name =  REPLACE (link_name,'ñ','ñ');
51UPDATE wp_options SET option_value =  REPLACE (option_value,'ñ','ñ');
52UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'ñ','ñ');
53UPDATE wp_users SET display_name =  REPLACE (display_name,'ñ','ñ');
54
55UPDATE wp_posts SET post_content = REPLACE(REPLACE(post_content,CHAR(173),''), CHAR(195), 'í');
56UPDATE wp_posts SET post_title =  REPLACE(REPLACE(post_title,CHAR(173),''), CHAR(195), 'í');
57UPDATE wp_comments SET comment_content =  REPLACE(REPLACE(comment_content,CHAR(173),''), CHAR(195), 'í');
58UPDATE wp_comments SET comment_author =  REPLACE(REPLACE(comment_author,CHAR(173),''), CHAR(195), 'í');
59UPDATE wp_links SET link_name =  REPLACE(REPLACE(link_name,CHAR(173),''), CHAR(195), 'í');
60UPDATE wp_options SET option_value =  REPLACE(REPLACE(option_value,CHAR(173),''), CHAR(195), 'í');
61UPDATE wp_usermeta SET meta_value =  REPLACE(REPLACE(meta_value,CHAR(173),''), CHAR(195), 'í');
62UPDATE wp_users SET display_name =  REPLACE(REPLACE(display_name,CHAR(173),''), CHAR(195), 'í');
63
64UPDATE wp_posts SET post_content = REPLACE (post_content,'´','´');
65UPDATE wp_posts SET post_title =  REPLACE (post_title,'´','´');
66UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'´','´');
67UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'´','´');
68UPDATE wp_links SET link_name =  REPLACE (link_name,'´','´');
69UPDATE wp_options SET option_value =  REPLACE (option_value,'´','´');
70UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'´','´');
71UPDATE wp_users SET display_name =  REPLACE (display_name,'´','´');
72
73UPDATE wp_posts SET post_content = REPLACE (post_content,'“','“');
74UPDATE wp_posts SET post_title =  REPLACE (post_title,'“','“');
75UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'“','“');
76UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'“','“');
77UPDATE wp_links SET link_name =  REPLACE (link_name,'“','“');
78UPDATE wp_options SET option_value =  REPLACE (option_value,'“','“');
79UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'“','“');
80UPDATE wp_users SET display_name =  REPLACE (display_name,'“','“');
81
82UPDATE wp_posts SET post_content = REPLACE (post_content,'  ',' ');
83UPDATE wp_posts SET post_title =  REPLACE (post_title,'  ',' ');
84UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'  ',' ');
85UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'  ',' ');
86UPDATE wp_links SET link_name =  REPLACE (link_name,'  ',' ');
87UPDATE wp_options SET option_value =  REPLACE (option_value, '  ',' ');
88UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'  ',' ');
89UPDATE wp_users SET display_name =  REPLACE (display_name,'  ',' ');
90
91UPDATE wp_posts SET post_content = REPLACE(REPLACE(post_content,CHAR(144),''), 'â€', '”');
92UPDATE wp_posts SET post_title =  REPLACE(REPLACE(post_title,CHAR(144),''), 'â€', '”');
93UPDATE wp_comments SET comment_content =  REPLACE(REPLACE(comment_content,CHAR(144),''), 'â€', '”');
94UPDATE wp_comments SET comment_author =  REPLACE(REPLACE(comment_author,CHAR(144),''), 'â€', '”');
95UPDATE wp_links SET link_name =  REPLACE(REPLACE(link_name,CHAR(144),''), 'â€', '”');
96UPDATE wp_options SET option_value =  REPLACE(REPLACE(option_value,CHAR(144),''), 'â€', '”');
97UPDATE wp_usermeta SET meta_value =  REPLACE(REPLACE(meta_value,CHAR(144),''), 'â€', '”');
98UPDATE wp_users SET display_name =  REPLACE(REPLACE(display_name,CHAR(144),''), 'â€', '”');
99
100UPDATE wp_posts SET post_content = REPLACE (post_content,CHAR(157),'');
101UPDATE wp_posts SET post_title =  REPLACE (post_title,CHAR(157),'');
102UPDATE wp_comments SET comment_content =  REPLACE (comment_content,CHAR(157),'');
103UPDATE wp_comments SET comment_author =  REPLACE (comment_author,CHAR(157),'');
104UPDATE wp_links SET link_name =  REPLACE (link_name,CHAR(157),'');
105UPDATE wp_options SET option_value =  REPLACE (option_value,CHAR(157),'');
106UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,CHAR(157),'');
107UPDATE wp_users SET display_name =  REPLACE (display_name,CHAR(157),'');
108
109UPDATE wp_posts SET post_content = REPLACE (post_content,',Â','´');
110UPDATE wp_posts SET post_title =  REPLACE (post_title,'´','´');
111UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'´','´');
112UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'´','´');
113UPDATE wp_links SET link_name =  REPLACE (link_name,'´','´');
114UPDATE wp_options SET option_value =  REPLACE (option_value,'´','´');
115UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'´','´');
116UPDATE wp_users SET display_name =  REPLACE (display_name,'´','´');
117
118UPDATE wp_posts SET post_content = REPLACE (post_content,',Â',',');
119UPDATE wp_posts SET post_title =  REPLACE (post_title,',Â',',');
120UPDATE wp_comments SET comment_content =  REPLACE (comment_content,',Â',',');
121UPDATE wp_comments SET comment_author =  REPLACE (comment_author,',Â',',');
122UPDATE wp_links SET link_name =  REPLACE (link_name,',Â',',');
123UPDATE wp_options SET option_value =  REPLACE (option_value,',Â',',');
124UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,',Â',',');
125UPDATE wp_users SET display_name =  REPLACE (display_name,',Â',',');