MyBB Community Forums

Hi maybe someone here with database knowledge could cover this with the right answer
So I have always wanted to know for future reference what is the best method in using CHARSET Tables  sql  .....

Example:

utf8_general_ci
vs
utf8_unicode_ci

Compared to.....

utf8mb4_general_ci
vs
utf8mb4_unicode_ci

utf8_ is broken and deprecated, always use utf8mb4_

https://dev.mysql.com/doc/refman/8.0/en/...f8mb3.html Wrote:Note
The utf8mb3 character set is deprecated and you should expect it to be removed in a future MySQL release. Please use utf8mb4 instead. Although utf8 is currently an alias for utf8mb3, at some point utf8 is expected to become a reference to utf8mb4. To avoid ambiguity about the meaning of utf8, consider specifying utf8mb4 explicitly for character set references instead of utf8.