I see that my forums have somehow automatically converted from the "utf8_bin" collation to "utf8mb3_bin", yet I don't know when this happened. I certainly did not change it. Is "utf8mb3_bin" now the recommended collation, and will this change when phpBB 4.0 comes out? If it will change for phpBB 4.0, what will it be?
This next part is not related to phpBB, but it has to do with phpBB being able to function. Regarding MySQL Community Server 8.x.x (presently 8.3.0), which collation is generally the best to use? At the moment, mine is showing "utf8mb4_0900_ai_ci". I have no problems with it, and I believe this is correct since it appears to be the "Default" one:
https://dev.mysql.com/doc/refman/8.3/en ... mysql.html
*Edit*
https://stackoverflow.com/questions/766 ... unicode-ci
Looks like "utf8mb4_unicode_520_ci" (Unicode 5.2) or "utf8mb4_0900_ai_ci" (MySQL 8.x) are the way to go for newer collations instead of "utf8mb4_unicode_ci" or "utf8mb4_general_ci".
-
Heo32
- Registered User
- Posts: 207
- Joined: Sat Jan 07, 2017 10:08 pm
phpBB 3.3.x Collation
Last edited by Heo32 on Mon Feb 26, 2024 4:08 pm, edited 1 time in total.
Allow using Content-Security-Policy without unsafe-inline • Content-Security-Policystevemaury wrote: Sun May 20, 2018 8:16 pm I went to your board and looked for an hour or so, but did not see the women without underwear.
-
rxu
- Extensions Development Team
- Posts: 3965
- Joined: Wed Oct 25, 2006 12:46 pm
- Location: Siberia, Russian Federation
Re: phpBB 3.3.x Collation
In MySQL,
https://dev.mysql.com/doc/refman/5.7/en ... -utf8.html
utf8 is an alias for utf8mb3. So utf8_bin is the same as utf8mb3_bin.https://dev.mysql.com/doc/refman/5.7/en ... -utf8.html