Where can I get correct information on MySQL database and table collation?

Jira Development Jira Server
1

This document says,

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

But the actual health check in my Jira instance says,

The database collation 'utf8mb4_bin' and table collation 'utf8mb4_bin' are not supported by Jira.

See the attached screenshot.

Screenshot from 2023-05-19 22-05-48
Screenshot from 2023-05-19 22-05-481080×539 32.7 KB

2

It seems that this is a bug in Jira 9.8.1. utf8mb4_bin collation is working fine on 9.4.2, with JRE 1.8.