Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titleCharacter sets and collation

MySQL 5.6 until version 8 has quite messy utf8 charset support. For MySQL 5.6 we can use utf8 charset (alias pointing to utf8mb3 - not full utf8) with collations like utf8_general_ci (case insensitive) or utf8_bin (case sensitive), but these collations will break order by - they compare only character code points, so upper case characters will be before lower case characters. From Mysql 8, mysql team recomends charset utf8mb4. Collation for correct searches would be utf8mb4_0900_as_cs. utf8mb4 is mainly necessary for deployments with extensive use of accented characters.

Note
titleHaving MariaDB and MySQL Drivers in the Same Classpath

Since MariaDB driver is bundled within midpoint.war and we want to use MySQL JDBC driver, we'll end up with two drivers that can handle jdbc:mysql://... To solve this issue we can follow MariaDB JDBC doc and use disableMariaDbDriver option. MariaDB driver will skip MySQL jdbc urls.

${midpoint-home}/config.xml repository configuration change

...