On Sat, Nov 07, 2015 at 04:48:28PM -0700, bluesun08 wrote: > ok. sorry. > > the real problem: > i have a windows application which needs a postgresql-database with > "de_DE.UTF-8" collation. > > When i try to create such a database in openbsd i get the error: > initdb: invalid locale name "de_DE.UTF-8" > > When i try to create the collation in postgres, i get the following error: > postgres=# CREATE COLLATION german (LOCALE = 'de_DE.utf8'); > ERROR: nondefault collations are not supported on this platform
OpenBSD doesn't provide LC_COLLATE locales. Is there another way to use collation in postgres which is independent of locales? Libraries like ICU (http://site.icu-project.org/) can support collation regardless of locale settings. Perhaps you should also ask your question in prostgres support forums.
