Actually the $wgLegacyEncoding thing probably wont work, because that would fix if it needed to be converted to utf8, but the issue here is (i think) it has been double converted to utf8
-- Brian On Sunday, September 11, 2022, Brian Wolff <bawo...@gmail.com> wrote: > 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 <zorandori4...@gmail.com> 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 <bawo...@gmail.com> је написао/ла: >> >>> ä 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 <zorandori4...@gmail.com> >>> 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@lists.wikimedia.org >>>> To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org >>>> https://lists.wikimedia.org/postorius/lists/mediawiki-l.list >>>> s.wikimedia.org/ >>> >>> _______________________________________________ >>> MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org >>> To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org >>> https://lists.wikimedia.org/postorius/lists/mediawiki-l.list >>> s.wikimedia.org/ >> >>
_______________________________________________ MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
