[wp-trac] [WordPress Trac] #38290: #1273 - Unknown collation: 'utf8_unicode_520_ci'

[WordPress Trac]

#38290: #1273 - Unknown collation: 'utf8_unicode_520_ci'
--------------------------+------------------------------
 Reporter:  immujune30    |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:  4.6.1
 Severity:  normal        |  Resolution:  invalid
 Keywords:                |     Focuses:
--------------------------+------------------------------
Changes (by immujune30):

 * status:  new => closed
 * resolution:   => invalid


Comment:

 At last i have solved it, but database collation replace
 utf8_unicode_520_ci with utf8_unicode_ci is didn't worked from me.

 Thanks for the response @pareshradadiya.

 My solution is something as follows.

 1. I have checked my localhost and my server db collation and make it same
 first of all.
 In my case i changed it to 'latin1_swedish_ci' ( we can find this in
 operations -> on the bottom right side "collation"
 2. after making the db collation same from both ends i.e your localhost db
 and your server db. download the database in mysql40 format.
 3. now upload the database into the server. ( it should upload without
 collation errors now, if not follow the 4th step )

 4. If it raising syntax error regarding InnoDB.

 5. then follow the instructions provided in the link
 http://stackoverflow.com/questions/9620439/syntax-error-when-running-a
 -mysql-create-table-statement

 6. Replace Instead of TYPE=INNODB set Engine=InnoDB. and upload the
 database again.

 That's it. In this way It should work 100%.


 As per my knowledge the problem is with the hosting mysql version and your
 localhost mysql version, and wordpress also enhanced its wordpress
 database tables from the wordpress 4.5.4 versions and above.

 other alternative solution is

 you can develop your website in localhost on the wordpress 4.5.4 version
 and make it upgrade at your server. It will not make any db collation
 issues while uploading.

 Thanks

--
Ticket URL: <https://core.trac.wordpress.org/ticket/38290#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform