Not that i am aware of. If there are any, they are probably from mediawiki 1.5 and dont work anymore. One possibility is to set $wgLegacyEncoding to ISO-8859-1, and remove utf-8 from the old_flags field ( https://www.mediawiki.org/wiki/Manual:Text_table#old_flags ), so that mediawiki thinks they are from pre mediawiki 1.5. You could also try a query like the following (i have not tested this, use at your own risk, have backups): UPDATE text SET `old_text`=convert(cast(cast(`old_text` AS CHAR CHARACTER SET latin1) AS BINARY) USING utf8) where old_flags not like '%gzip%'; -- Brian On Sunday, September 11, 2022, Zoran Dori &lt;zorandori4444(a)gmail.com&gt; wrote: > Hello Brian, > it was previously on version 1.31, I've upgraded it to the latest > version, hoping that it will resolve all issues. :) > > I've checked PHPMyAdmin, and they gave me access to it, and it shows > the same article perfectly fine, without any weird characters, after I've > changed encoding from latin1 to UTF-8. > > But on the wiki itself, a character is shown incorrectly still. Is > there any way where I can trigger MediaWiki to rebuild the database and > show things correctly? > > Looking forward to your response. :) > > Best regards, > Zoran > > суб, 10. сеп 2022. у 01:57 Brian Wolff &lt;bawolff(a)gmail.com&gt; је > написао/ла: > >> ä is what you get when you take ä encoded as UTF-8 and interpret it >> as ISO-8859-1. So what probably happened, is that some text that was >> encoded as UTF-8 was treated as if it was ISO-8859-1/windows1252 and >> (unessearily) converted to UTF-8. >> >> Common causes of this sort of thing: >> - Very very old wiki from before MediaWiki adopted UTF-8 that wasn't >> upgraded properly. (I think MW adopted UTF-8 before MediaWiki 1.5, so it >> would have to be truly ancient). >> - Restoring a DB from backup with some wrong options related to >> charset >> - converting the charset of DB columns if they were originally >> mislabeled. >> >> If its the entire DB that is broken, I think the easiest fix might be >> to take a DB dump, and use the iconv command line tool to convert UTF-8 -> >> windows-1252 (To undo one layer of conversion) and then import the result >> as if it was UTF-8. >> >> -- >> brian. >> >> >> On Thu, Sep 8, 2022 at 3:13 AM Zoran Dori &lt;zorandori4444(a)gmail.com&gt; >> wrote: >> >>> Hello, >>> I'm working on one wiki which shows characters in a weird way. UTF-8 >>> is used for encoding, so I believe that it isn't an issue. >>> >>> You can take a look here Statik A – Sub Bavaria (sub-bavaria.de) >>> <http://www.sub-bavaria.de/w/index.php?title=Statik_A>, so you can >>> better understand what I'm talking about. >>> >>> Could you please point me to something that I should look for, so I >>> can fix this issue? >>> Wiki was previously on version 1.31, I've upgraded it to 1.38. >>> >>> Thanks for your help and understanding! >>> >>> Best regards, >>> Zoran >>> _______________________________________________ >>> MediaWiki-l mailing list -- mediawiki-l(a)lists.wikimedia.org >>> To unsubscribe send an email to >>> mediawiki-l-leave(a)lists.wikimedia.org >>> >>> https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/ >> >> _______________________________________________ >> MediaWiki-l mailing list -- mediawiki-l(a)lists.wikimedia.org >> To unsubscribe send an email to mediawiki-l-leave(a)lists.wikimedia.org >> >> https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/ > > _______________________________________________