Jump to content

utf8mb4 Converter


Sonya*

Recommended Posts

I was trying to allow emojis on my test server with 4.3.6. And I get the message below:

 

screenshot-2018_11.02-21-57-17.thumb.png.2573215fd6ce685282ad1dc97c455899.png

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.:unsure:

Link to comment
Share on other sites

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

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...