Blog Archive for December 16, 2011

Norwegian Sorting on Postgres 8.4

December 16, 2011

I wanted to create a database in postgres 8.4 that had norwegian sorting on text, so that accented characters were sorted in the correct place.

I tried this using a simple create database command, but it failed as the locale was not found.

postgres=# create database test with encoding 'utf8' …