Sitemap not UTF-8 ?

Question

Hi,

sitemap doesnt show ä ö ü. also the questions are reachable with and without the special characters.

I think this could be a duplicate content problem. Can anyone advise how to fix this?

Answer 1

Great catch! This is indeed a bug in the XML Sitemap plugin. You can fix it by changing this in qa-xml-sitemap.php:

SELECT postid, title, upvotes, downvotes

... to ...

SELECT postid, BINARY title AS title, upvotes, downvotes

This will of course be fixed in the 1.3 release.

Comments

Now %C3%BC shows as ü. (I think before there was no character at all).
It this correct?

---

Yes, this is the two-byte UTF-8 representation of the character, encoded for URLs.

---

Tag has this issuet to

Change

SELECT wordid, word, tagcount

to

SELECT wordid, BINARY word AS word, tagcount

can fix it.

---

Indeed, and this for the users:

SELECT userid, BINARY handle AS handle FROM ...