Sonya* Posted November 2, 2018 Share Posted November 2, 2018 I was trying to allow emojis on my test server with 4.3.6. And I get the message below: My tables have collation utf8mb4_unicode_ci. In my conf_global.php I have these 2 lines: $INFO['sql_charset'] = 'utf8'; $INFO['sql_utf8mb4'] = 'true'; What is wrong with my collation? Edit: Can I simply change sql_charset to utf8mb4 or must I convert? Edit 2: Changing above has not solve anything. IPS still suggests to convert. But all tables ARE already utf8mb4_unicode_ci. Link to comment Share on other sites More sharing options...
Rhett Posted November 3, 2018 Share Posted November 3, 2018 Set this line as follows. $INFO['sql_utf8mb4'] = true; Link to comment Share on other sites More sharing options...
Sonya* Posted November 3, 2018 Author Share Posted November 3, 2018 2 minutes ago, Rhett said: Set this line as follows. $INFO['sql_utf8mb4'] = true; I have already this line in my conf_global.php (s. above). I assume that it's my server connection charset that is utf8_unicode_ci. That's why I get this message. I will try to change server connection charset and will see if the message to convert to utf8mb4 disappears then. Link to comment Share on other sites More sharing options...
Rhett Posted November 3, 2018 Share Posted November 3, 2018 8 minutes ago, Sonya* said: I have already this line in my conf_global.php (s. above). I assume that it's my server connection charset that is utf8_unicode_ci. That's why I get this message. I will try to change server connection charset and will see if the message to convert to utf8mb4 disappears then. Look closer, copy and paste the code I provided (it's different), then check it.. should be ok. You have $INFO['sql_utf8mb4'] = 'true'; and it should be $INFO['sql_utf8mb4'] = true; Link to comment Share on other sites More sharing options...
Sonya* Posted November 3, 2018 Author Share Posted November 3, 2018 true without quotes So simple, Shame on me Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.