...
| 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.
...