Change sort order by locale collation
Consider this example:
PostgreSQL is expanding "Æ" into "AE"- which is a correct rule for English.
However, in Danish the correct order will be
Change locale collation
By default Aidbox uses en_US.utf8 locale. Aidboxdb version 14.7 supports locale collation changes. To change cluster locale to Danish, use PostgreSQL locale variables:
docker-compose.yaml
If these variables were set before the first start of aidboxdb (i.e. when the cluster is not initialized yet), then PostgreSQL will set cluster (and database) locales from environment variables.
Hence the SQL request
Will return the right order for Danish locale.
Any _sort Search Parameter will also consider Danish sort order.
Last updated