Redirection plugin and UTF-8

  • Foliovision: Making the web work for you

    (@foliovision)


    13 years, 5 months 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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author John Godley

    (@johnny5)

    13 years, 5 months 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.

    ajuliano

    (@ajuliano)

    12 years, 6 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!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Redirection plugin and UTF-8’ is closed to new replies.