1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 Converting to UTF8MB4

Discussion in 'XenForo Questions and Support' started by bottiger, Dec 16, 2014.

  1. bottiger

    bottiger Active Member

    As you may have heard, MySQL utf8 is not actually utf8. It only goes up to 3 bytes instead of 4.

    So I converted all my databases to utf8mb4 including all the fields. But I am still getting this error occasionally.

    Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

    I am wondering if all I need to do is change library/XenForo/Application.php on line 712 to utf8mb4.

    'charset' => 'utf8'
     

Share This Page