table structure of table `_commentmeta`

  • I am migrating my SQL and am getting this error

    #1273 – Unknown collation: ‘utf8_unicode_520_ci’

    What do I do to solve this? This is an issue I have never ran into

Viewing 2 replies - 1 through 2 (of 2 total)

  • I’m not sure if it’s the same thing but there are a number of useful suggestions on this discussion thread… https://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel

    Wordpress 4.6 now prefers collation method utf8_unicode_520_ci when it is available, which would be on Mysql version 5.6 and above. I’m not sure if this is what has happened in your case, but if your local server is running Mysql ver 5.6 or higher when you set up your installation, WordPress will use ‘utf8_unicode_520_ci’. The problem is many hosts are running some older version of Mysql which does not support it, and so when you try to migrate to the server the new collation method is not recognized and the migration fails.

    You might ask your host to upgrade to Mysql 5.6, but some hosts may not want to do that.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘table structure of table `_commentmeta`’ is closed to new replies.