Hello, I have been upgrading several sites from WB 2.8.3 to 2.12.2, and everyone of them breaks the accented characters. So, I have to do an extra step each time and run SQL commands via phpMyAdmin to replace the meesed up characters, like:
UPDATE wb_pages
SET page_title = Replace(page_title, '¿', '¿');
UPDATE wb_pages
SET description = Replace(description, 'á', 'á');
And so on, for each accented character and each module. It's not a problem for me as I already have the list of commands to replace the Spanish characters and run them all at once... HOWEVER, I have to upgrade a site which is also in RUSSIAN with cyrillic alphabet, and since I don't know Russian, if it breaks I won't know which commands to run to replace the messed up characters.
SO, MY QUESTIONS ARE:
1) Is there a way to prevent the characters from getting messed up BEFORE upgrading?
2) If not, does someone have a list of all the replacement commands for Russian, or could someone help me generate it? For example, this is what I use for the Pages Titles in Spanish:
UPDATE wb_pages
SET page_title = Replace(page_title, 'á', 'á');
UPDATE wb_pages
SET page_title = Replace(page_title, 'é', 'é');
UPDATE wb_pages
SET page_title = Replace(page_title, 'Ã', 'í');
UPDATE wb_pages
SET page_title = Replace(page_title, 'ó', 'ó');
UPDATE wb_pages
SET page_title = Replace(page_title, 'ú', 'ú');
UPDATE wb_pages
SET page_title = Replace(page_title, 'ñ', 'ñ');
UPDATE wb_pages
SET page_title = Replace(page_title, 'Ã', 'Á');
UPDATE wb_pages
SET page_title = Replace(page_title, 'É', 'É');
UPDATE wb_pages
SET page_title = Replace(page_title, 'Ó', 'Ó');
UPDATE wb_pages
SET page_title = Replace(page_title, 'Ú', 'Ú');
UPDATE wb_pages
SET page_title = Replace(page_title, '¿', '¿');