I currently use MariaDB as a SQL DB for HA and while it works need wipe is and start again.
I had a look in the docs on the HA site, and also the docs for the ‘recorder’ component, but there is no info on what settings to use when setting up a SQL db.
I’ve seen some random guides saying you should use ‘utf8mb4_unicode_ci’, while others say ‘utf8_general_ci’ should be used for example.
If there was something in the official docs / recorder component I’d rather use that info rather than random guides that are often incorrect.