• Welcome to XF2 Addons

    You can purchase a Premium membership for only $35 per year, and this gives you access to download any or ALL of the over 400 add-ons developed for Xenforo 2.x. In addition, Premium members will get technical support. Once the Premium membership has expired you can continue to use the installed addons on your forum as long as you like.

Updating collation type using phpMyAdmin

Andy

Administrator
Staff member
Here are the steps to change the collation from uft8mb3_general_ci to utf8mb4_general_ci in a selected database.

Go to phpMyAdmin
Select database

With the Structure tab selected, verify all Collations for each table are of the uft8mb3_general_ci type.

Click the Operations tab
In the Collation section, select utf8mb4_general_ci and check these two options:

Change all table collations
Change all table column collations

Click Go
 
Top