Jump to the post that solved this thread.
Solved: 1 Year ago Your database encoding is 'utf8', should be 'utf8mb4'. Please update your MyBB to use
#1
Solved: 1 Year ago
hello

i find this message in ACP

Your database encoding is 'utf8', should be 'utf8mb4'. Please update your MyBB to use UTF-8 everywhere.

how to fix this problem

thank you
[Image: ziuma.jpg]    
Reply
#2
Solved: 1 Year ago
The only way is to access your database (console or phpMyAdmin) and run:
ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; (replace databasename with the name of your base)
And for each table in it: ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

You can create a query to generate all the queries:
SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;') as qry FROM information_schema.tables WHERE table_schema = 'databasename';
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply
#3
Solved: 1 Year ago
MyBB has a build in UTF-8 Conversion Tool. There is no need to run SQL queries on your own.
[Image: banner.png]
Reply
#4
Solved: 1 Year ago
I'm also having this issue with the Google SEO plugin, should i convert it to as the plugin says without any complications?

   

@stefan, are you talking about this?

   
Reply
#5
Solved: 1 Year ago
(2020-08-12, 02:59 PM)StefanT Wrote: MyBB has a build in UTF-8 Conversion Tool. There is no need to run SQL queries on your own.
Oh yes, I forgot that Smile You're true.

(2020-08-12, 03:12 PM)kbilly Wrote: I'm also having this issue with the Google SEO plugin, should i convert it to as the plugin says without any complications?

@stefan, are you talking about this?
Yes, is speaking about this tool, and you can convert all tables without any trouble, but think to backup your database before, and close your forum.
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply
#6
Solved: 1 Year ago
(2020-08-12, 02:59 PM)StefanT Wrote: MyBB has a build in UTF-8 Conversion Tool. There is no need to run SQL queries on your own.
Explain that please.

I had to convert my site manually. I set the encoding in config but my tables had to be converted for it to work properly.

What tool are you talking about?
Reply
#7
Solved: 1 Year ago
This user has been denied support. This user has been denied support.
admincp - admin/index.php?module=tools-system_health&action=utf8_conversion

Make a backup in any case before performing database conversions.

Google SEO recommended 'utf8' charset before which is outdated. 4-byte UTF-8 characters used to be exotic (some chinese characters and other unusual scripts) but became more prevalent with emoji and stuff.

Also a few years ago it was still common to find outdated MySQL server that didn't even support 4-byte UTF-8. Nowadays it should not be a problem anymore, so the default choice should be utf8mb4, not utf8.

Even if you are not planning on using such characters actively, weird behavior occurs when users post them anyway. Switching to utf8mb4 should resolve that issue.

Even so, if you didn't have issues until now, it's also fine to leave as is. You can ignore this message and treat it as informative.
Reply
#8
Solved: 1 Year ago
[Image: attachment.php?aid=43184]

this picture help me
thank you
[Image: ziuma.jpg]    
Reply
#9
Solved: 1 Year ago
(2020-08-12, 02:59 PM)StefanT Wrote: MyBB has a build in UTF-8 Conversion Tool. There is no need to run SQL queries on your own.

the tool is doing nothing any ideas?
mysql 8
Pokemon Style With Lots Of Maps Monster MMORPG Game Developer
Reply
#10
Solved: 1 Year ago
Remember to change the encoding in inc/config.php too after running the tool.
$config['database']['encoding'] = 'utf8mb4';
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)