MyBB Community Forums

mybb version: 1.8.37
mysql version: 8.036

Hello,

im trying to use emojis on mybb so after some google i found out i need to convert the db from utf8 to utf8mb4.

here is the issue; when i go to the  UTF-8 Conversion Tool page, this is what i see:

[attachment=46614]

the 4-bit support column is empty.

(my server mysql version is 8.036, so i meet the minimum MySQL 5.5.3 requirement.)

i clicked on convert all to ut8, and the msg says You are about to convert ALL tables to UTF-8 language encoding from utf8mb3 encoding. 
uh?
i clicked convert, the tool did their thing for a minute, but the db is still in utf8.

i changed config.php to utf8 utf8mb4

$config['database']['encoding'] = 'utf8mb4';

but that didnt work.
(reading the config.php i noticed im using mysqli, idk if that could be the issue?)

so, i dont really know what else to do.
do i need to do the change it manually as explained here? if that's the case: do  need to alter the database and tables? or do i need to alter columns too?

isnt it "utf8mb4_bin"? At least that is what my db tells me

---

Maybe this helps. My webhoster is still on 5.7 so for me it is _bin.

https://www.percona.com/blog/charset-and...rformance/

---

so after reading, how about

Quote:

$config['database']['encoding'] = 'utf8mb4_0900_ai_ci';

Try reading the following :
https://community.mybb.com/thread-239572...pid1389754

In summary:

We have two links what give advices on how to bring all on Utf8mb4 and one link what shows one of the fastest Utf8mb4 for Mysql 8,x, the Utf8mb4_0900_ai_ci, what is also the standard Utf8mb4 for Mysql 8.x. So no more need for me to have subscription here.

(2024-02-08, 05:04 AM)Omar G. Wrote: [ -> ]Try reading the following :
https://community.mybb.com/thread-239572...pid1389754

this fixed it!
thank you!!