search

XOOPS / XoopsCore25

XOOPS Core 2.5.x (current release is 2.5.11: https://github.com/XOOPS/XoopsCore25/releases)
GNU General Public License v2.0
71 stars 59 forks source link

XOOPS 2.5.11beta2 - Installation - Database - Warning #1249

Open alain01 opened 2 years ago

alain01 commented 2 years ago

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.

Capture d’écran 2022-08-10 143350

mambax7 commented 2 years ago

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

alain01 commented 2 years ago

Ok, tomorrow !

ihackcode commented 2 years ago
  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.