phpBB 3.3.x Collation

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Anti-Spam Guide
Heo32
Registered User
Posts: 207
Joined: Sat Jan 07, 2017 10:08 pm

phpBB 3.3.x Collation

Post by Heo32 »

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".
Last edited by Heo32 on Mon Feb 26, 2024 4:08 pm, edited 1 time in total.
stevemaury 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.
Allow using Content-Security-Policy without unsafe-inline • Content-Security-Policy
rxu
Extensions Development Team
Posts: 3804
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation

Re: phpBB 3.3.x Collation

Post by rxu »

In MySQL, 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

Return to “phpBB Discussion”