we recently made a mistake and we ended up with a post which had a slug like this:
The URL encoded characters read ﬁ (it's like f and i letters, but joined together into a single symbol) when decoded into UTF8. We fixed the post, but the old URL stopped working.
I wasn't able to place any rule for it into the Redirection plugin until I changed the collation for the
url field of
wp_redirection_items to utf8_general_ci. Then I was able to insert that funny characters into it and the old weird URL is 301 redirected to new one. I wasn't able to use the URL encoded chars, so this seems like the only solution.
Why aren't all the Redirection tables in UTF-8 by default?