WordPress.org

1. FolioVision
   Member
   Posted 1 year ago #

   Hello,

   we recently made a mistake and we ended up with a post which had a slug like this:

   toronto-%EF%AC%81lm

   The URL encoded characters read fi (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?

   Thanks,
   Martin

2. John
   Member
   Posted 1 year ago #

   The tables are created in whatever charset you have WP setup with, or whatever your DB default is if you don't configure WP.

3. ajuliano
   Member
   Posted 8 months ago #

   Hi,

   @John, i'm not sure that you are right here. Because I have WP setup with utf8_general_ci, and thats what my DB default is also. But the Redirection tables are setup in latin1_swedish_ci (I'm swedish).

   Is it a bug in the plugin? For now I will do as FolioVison, changing the collation myself.

   Btw Awesome plugin!

Topic Closed

This topic has been closed to new replies.