Not that i am aware of. If there are any, they are probably from mediawiki 1.5 and dont work anymore.<div><br></div><div>One possibility is to set $wgLegacyEncoding to ISO-8859-1, and remove utf-8 from the old_flags field (<a href="https://www.mediawiki.org/wiki/Manual:Text_table#old_flags">https://www.mediawiki.org/wiki/Manual:Text_table#old_flags</a> ), so that mediawiki thinks they are from pre mediawiki 1.5.</div><div><br></div><div>You could also try a query like the following (i have not tested this, use at your own risk, have backups):</div><div><div>UPDATE text SET `old_text`=convert(cast(cast(`old_text` AS CHAR CHARACTER SET latin1) AS BINARY) USING utf8) where old_flags not like &#39;%gzip%&#39;;</div></div><div><br></div><div>--</div><div>Brian</div><div><br>On Sunday, September 11, 2022, Zoran Dori &lt;<a href="mailto:zorandori4444@gmail.com">zorandori4444@gmail.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello Brian,<div>it was previously on version 1.31, I&#39;ve upgraded it to the latest version, hoping that it will resolve all issues. :)</div><div><br></div><div>I&#39;ve checked PHPMyAdmin, and they gave me access to it, and it shows the same article perfectly fine, without any weird characters, after I&#39;ve changed encoding from latin1 to UTF-8.</div><div><br></div><div>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?</div><div><br></div><div>Looking forward to your response. :)</div><div><br></div><div>Best regards,</div><div>Zoran</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">суб, 10. сеп 2022. у 01:57 Brian Wolff &lt;<a href="mailto:bawolff@gmail.com" target="_blank">bawolff@gmail.com</a>&gt; је написао/ла:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>ä 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.<br></div><div><br></div><div>Common causes of this sort of thing:</div><div>- Very very old wiki from before MediaWiki adopted UTF-8 that wasn&#39;t upgraded properly. (I think MW adopted UTF-8 before MediaWiki 1.5, so it would have to be truly ancient).</div><div>- Restoring a DB from backup with some wrong options related to charset</div><div>- converting the charset of DB columns if they were originally mislabeled.<br></div><div dir="ltr"><br></div><div>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 -&gt; windows-1252 (To undo one layer of conversion) and then import the result as if it was UTF-8.<br></div><div dir="ltr"><br></div><div>--</div><div>brian.</div><div><br></div><div><br></div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Sep 8, 2022 at 3:13 AM Zoran Dori &lt;<a href="mailto:zorandori4444@gmail.com" target="_blank">zorandori4444@gmail.com</a>&gt; wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr">Hello,<div>I&#39;m working on one wiki which shows characters in a weird way. UTF-8 is used for encoding, so I believe that it isn&#39;t an issue.</div><div><br></div><div>You can take a look here <a href="http://www.sub-bavaria.de/w/index.php?title=Statik_A" target="_blank">Statik A – Sub Bavaria (sub-bavaria.de)</a>, so you can better understand what I&#39;m talking about.</div><div><br></div><div>Could you please point me to something that I should look for, so I can fix this issue?</div><div>Wiki was previously on version 1.31, I&#39;ve upgraded it to 1.38.</div><div><br></div><div>Thanks for your help and understanding!</div><div><br></div><div>Best regards,</div><div>Zoran</div></div></div>
______________________________<wbr>_________________<br>
MediaWiki-l mailing list -- <a href="mailto:mediawiki-l@lists.wikimedia.org" target="_blank">mediawiki-l@lists.wikimedia.<wbr>org</a><br>
To unsubscribe send an email to <a href="mailto:mediawiki-l-leave@lists.wikimedia.org" target="_blank">mediawiki-l-leave@lists.<wbr>wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/" rel="noreferrer" target="_blank">https://lists.wikimedia.org/<wbr>postorius/lists/mediawiki-l.<wbr>lists.wikimedia.org/</a></blockquote></div></div>
______________________________<wbr>_________________<br>
MediaWiki-l mailing list -- <a href="mailto:mediawiki-l@lists.wikimedia.org" target="_blank">mediawiki-l@lists.wikimedia.<wbr>org</a><br>
To unsubscribe send an email to <a href="mailto:mediawiki-l-leave@lists.wikimedia.org" target="_blank">mediawiki-l-leave@lists.<wbr>wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/" rel="noreferrer" target="_blank">https://lists.wikimedia.org/<wbr>postorius/lists/mediawiki-l.<wbr>lists.wikimedia.org/</a></blockquote></div>
</blockquote></div>