Intersezione Dev Blog

Ecco alcune query di esempio per tradurre errori ricorrenti nei campi di un db causati da una Collation errata o da testi ai quali era applicato uno stile sbagliato.

UPDATE Page SET Abstract = replace(Abstract, '’', '\'');
UPDATE Page_Live SET Abstract = replace(Abstract, '’', '\'') ;
UPDATE Page SET Abstract = replace(Abstract, 'Ã', 'à') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'Ã', 'à') ;
UPDATE Page SET Abstract = replace(Abstract, 'à¹' , 'ù') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'à¹' , 'ù') ;
UPDATE Page SET Abstract = replace(Abstract, 'ù', 'ù') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'ù', 'ù') ;
UPDATE Page SET Abstract = replace(Abstract, '€œ', '\"') ;
UPDATE Page_Live SET Abstract = replace(Abstract, '€œ', '\"') ;
UPDATE Page SET Abstract = replace(Abstract, 'â€', '\"') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'â€', '\"') ;
UPDATE Page SET Abstract = replace(Abstract, 'è','è') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'è','è') ;
UPDATE Page SET Abstract = replace(Abstract, 'á', 'à') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'á', 'à') ;
UPDATE Page SET Abstract = replace(Abstract, 'à©' , 'è') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'à©' , 'è') ;
UPDATE Page SET Abstract = replace(Abstract, 'à¨' , 'è') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'à¨' , 'è') ;
UPDATE Page SET Abstract = replace(Abstract, '
' , ' ') ;
UPDATE Page_Live SET Abstract = replace(Abstract, '
' , ' ') ;
UPDATE Page SET Abstract = replace(Abstract, 'Â' , ' ') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'Â' , ' ') ;
UPDATE Page SET Abstract = replace(Abstract, 'à²' , 'ò') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'à²' , 'ò') ;
UPDATE Page SET Abstract = replace(Abstract, 'à¬' , 'ì') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'à¬' , 'ì') ;
UPDATE Page SET Abstract = replace(Abstract, 'à¡' , '') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'à¡' , '') ;
UPDATE Page SET Abstract = replace(Abstract, 'â' , '') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'â' , '') ;

UPDATE SiteTree SET Content = replace(Content, '’', '\'');
UPDATE SiteTree_Live SET Content = replace(Content, '’', '\'') ;
UPDATE SiteTree SET Content = replace(Content, 'Ã', 'à') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'Ã', 'à') ;
UPDATE SiteTree SET Content = replace(Content, 'ù', 'ù') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'ù', 'ù') ;
UPDATE SiteTree SET Content = replace(Content, '€œ', '\"') ;
UPDATE SiteTree_Live SET Content = replace(Content, '€œ', '\"') ;
UPDATE SiteTree SET Content = replace(Content, 'â€', '\"') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'â€', '\"') ;
UPDATE SiteTree SET Content = replace(Content, 'è','è') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'è','è') ;
UPDATE SiteTree SET Content = replace(Content, 'á', 'à') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'á', 'à') ;
UPDATE SiteTree SET Content = replace(Content, 'à©' , 'è') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'à©' , 'è') ;
UPDATE SiteTree SET Content = replace(Content, 'à¨' , 'è') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'à¨' , 'è') ;
UPDATE SiteTree SET Content = replace(Content, 'à¹' , 'ù') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'à¹' , 'ù') ;
UPDATE SiteTree SET Content = replace(Content, '
' , ' ') ;
UPDATE SiteTree_Live SET Content = replace(Content, '
' , ' ') ;
UPDATE SiteTree SET Content = replace(Content, 'Â' , ' ') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'Â' , ' ') ;
UPDATE SiteTree SET Content = replace(Content, 'à²' , 'ò') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'à²' , 'ò') ;
UPDATE SiteTree SET Content = replace(Content, 'à¬' , 'ì') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'à¬' , 'ì') ;
UPDATE SiteTree SET Content = replace(Content, 'à¡' , '') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'à¡' , '') ;
UPDATE SiteTree SET Content = replace(Content, 'â' , '') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'â' , '') ;

UPDATE SiteTree SET Title = replace(Title , 'aÌ€', 'à') ;
UPDATE SiteTree_Live SET Title = replace(Title , 'aÌ€', 'à') ;

UPDATE Page SET Abstract = replace(Abstract, 'margin-top: 0.34cm; margin-bottom: 0.34cm; background: #ffffff;

line-height: 100%' , '') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'margin-top: 0.34cm; margin-bottom: 0.34cm; background: #ffffff;

line-height: 100%' , '') ;

UPDATE Page SET Abstract = replace(Abstract, 'margin-bottom: 0cm; line-height: 100%' , '') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'margin-bottom: 0cm; line-height: 100%' , '') ;

UPDATE Page SET Abstract = replace(Abstract, 'margin-bottom: 0cm; line-height: 0.37cm;' , '') ;
UPDATE Page_Live SET Abstract = replace(Abstract, 'margin-bottom: 0cm; line-height: 0.37cm;' , '') ;

UPDATE SiteTree SET Content = replace(Content, 'margin-top: 0.34cm; margin-bottom: 0.34cm; background: #ffffff;

line-height: 100%' , '') ;
UPDATE SiteTree_Live SET Content = replace(Content, 'margin-top: 0.34cm; margin-bottom: 0.34cm; background: #ffffff;

line-height: 100%' , '') ;