querys interogari sql pentru diacritice
DESCRIPTION
descarca astea pentru a avea diacrtitice in baza de date din iso 9000 in utfTRANSCRIPT
�UPDATE econ_k2_items SET title = REPLACE(title, 'È™', 'ș');UPDATE econ_k2_items SET title = REPLACE(title, 'ÃŽ', 'Î');UPDATE econ_k2_items SET title = REPLACE(title, 'ă', 'ă');UPDATE econ_k2_items SET title = REPLACE(title, 'Èš', '�');UPDATE econ_k2_items SET title = REPLACE(title, 'î', 'î');UPDATE econ_k2_items SET title = REPLACE(title, 'â', 'â');UPDATE econ_k2_items SET title = REPLACE(title, 'È›', '�');
UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'È™', 'ș');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'ÃŽ', 'Î');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'ă', 'ă');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'ã', 'ă');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'Èš', '�');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'î', 'î');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'â', 'â');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, 'È›', '�');UPDATE econ_k2_items SET `fulltext` = REPLACE(`fulltext`, '–', '-');
UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'È™', 'ș');UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'ÃŽ', 'Î');UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'ă', 'ă');UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'Èš', '�');UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'î', 'î');UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'â', 'â');UPDATE econ_k2_items SET `introtext` = REPLACE(`introtext`, 'È›', '�');
UPDATE econ_menu SET title = REPLACE(title, 'È™', 'ș');UPDATE econ_menu SET title = REPLACE(title, 'ÃŽ', 'Î');UPDATE econ_menu SET title = REPLACE(title, 'ă', 'ă');UPDATE econ_menu SET title = REPLACE(title, 'Èš', '�');UPDATE econ_menu SET title = REPLACE(title, 'î', 'î');UPDATE econ_menu SET title = REPLACE(title, 'â', 'â');UPDATE econ_menu SET title = REPLACE(title, 'È›', '�');
UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'È™', 'ș');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'ÃŽ', 'Î');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'ă', 'ă');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'Èš', '�');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'î', 'î');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'â', 'â');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'È›', '�');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'Å£', '�');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, '–', '-');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'ÅŸ', 'ș');UPDATE econ_content SET `introtext` = REPLACE(`introtext`, 'Åž', 'Ș');
UPDATE econ_content SET `fulltext` = REPLACE(`fulltext`, 'Åž', 'Ș');