The default collation for tables in phpMyAdmin is utf8mb4_general_ci but should be utf8mb4_unicode_ci. This setting might be server thing or a phpMyAdmin setting. I cannot remember it has been a while.
The 'Server connection collation' is already utf8mb4_unicode_ci
utf8mb4_unicode_ci is a much more efficient search algorithm and the extra overheads are minimal. This is also the standard collation that WordPress now uses for its tables where it can.
I can probably figure out how to change this myself, but for new installs this should be set tot he new collation of utf8mb4_unicode_ci
shoulders
Default database collation should be utf8_unicode_ci
Re: Default database collation should be utf8_unicode_ci
Hello,
it is the default setting of MariaDB. Keyhelp does not change anything here.
it is the default setting of MariaDB. Keyhelp does not change anything here.
Mit freundlichen Grüßen / Best regards
Florian Cheno
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Florian Cheno
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Re: Default database collation should be utf8_unicode_ci
Then maybe KeyHelp could change this setting with a modification to a script. This is a really poor collation to be using.
For reference:
For reference:
Last edited by shoulders on Thu 26. Oct 2023, 12:11, edited 1 time in total.
Re: Default database collation should be utf8_unicode_ci
Then the DBA should use what he likes better, you can change it anytime. The defaults are not really important.
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Re: Default database collation should be utf8_unicode_ci
You may want to ask the operating system vendors, why they set the default to utf8mb4_general_ci instead of utf8mb4_unicode_ci.
I had a look:
- Ubuntu 22 uses utf8mb4_general_ci
- Debian 12 uses utf8mb4_general_ci
Mit freundlichen Grüßen / Best regards
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************