...
| Database | Characters set | Collation |
|---|---|---|
PostgreSQL | utf8 |
|
MariadDB | utf8mb4 | utf8mb4_unicode_ci |
MYSQL | utf8mb4 | utf8mb4_unicode_ci |
MSSQL | UCS-2 / UTF-16 | Latin1_General_CI SQL_Latin1_General_CP1_CI |
HSQL | NOT RELEVANT | NOT RELEVANT |
Using this combination ensures better global language support and consistent case-insensitive behavior in text comparisons.
PostgreSQL details
Until Unimus 2.6, only PostgreSQL 11 or older were supported. Starting with Unimus 2.6, we now support all newer version of Postgre.
If you wish to migrate from an older Postgre version to newer, please see the instructions below.
Step by step for PostgreSQL migration:
...