XOOPS 2.5.11beta2 - Installation - Database - Warning

[alain01]

2 remarks :
1 - Why by default it's display "7 bit swadich" ?
2 - Warning (see the printscreen above)

XOOPS Version	XOOPS 2.5.11-Beta2
PHP Version	8.1.8
MySQL Version	8.0.29

Then installation works fine... to the last page.

[mambax7]

@alain01, I was able to reproduce it!
Thanks for testing and reporting!

[alain01]

Ok, tomorrow !

[ihackcode]

1. it looks like the Installer is trying to select utf8 as the default.

Xoops will need a new recommended character set for MySQL 8.0+

Some relevant information. https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html

utf8 has been used by MySQL is an alias for the utf8mb3 character set, but this usage is being phased out; as of MySQL 8.0.28, SHOW statements and columns of Information Schema tables display utf8mb3 instead. For more information, see Section 10.9.2, “The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)”.

Note
The utf8mb3 character set is deprecated and you should expect it to be removed in a future MySQL release. Please use utf8mb4 instead. utf8 is currently an alias for utf8mb3, but it is now deprecated as such, and utf8 is expected subsequently to become a reference to utf8mb4. Beginning with MySQL 8.0.28, utf8mb3 is also displayed in place of utf8 in columns of Information Schema tables, and in the output of SQL SHOW statements.

To avoid ambiguity about the meaning of utf8, consider specifying utf8mb4 explicitly for character set references.