• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Which collation for Xenforo?

Triops

Well-known member
#1
Reading this and launching in two days I just overthink, what would be the best collation for the Xenforo 1.5 database:
https://xenforo.com/community/threads/utf8mb4_unicode_ci-instead-of-utf8mb4_general_ci.134960/

I have a German board with Umlauten öäüßÖÄÜ and several foreign European visitors with additional accents.
I would prefer, that searching for such accents like ä would deliver search results with ae, and ß finds ss too.

What I not would like would be search results with a for ä, or single s for ß. That would be wrong.
  • So, would utf8mb4_unicode_ci the best for my board?
  • Can I just create the database with that or will I run into errors or faulty behaviour?
  • Will the import from vBulletin (collation latin1_german_ci) with "force characterset" utf8 work coorectly, as importing into utf8_general_ci in my tests?
Thank you for any hint about this!