Triops
Well-known member
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.
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?
