Hi Ben, than You for answer. My PostgreSQL instance works fine. The problem is
in OpenBSD unfortunately. PostgreSQL uses COLLATION support served by operating system and default BSD has C and POSSIX COLLATION. I am looking for solution for this problem. I need native support for polish language with specific string sorts. Regards, Artur On Sun, 24 Jun 2007 18:47:29 -0700, Ben Calvert <[EMAIL PROTECTED]> wrote: > On Jun 24, 2007, at 1:41 PM, bsd_news wrote: > >> Hi >> I like OpenBSD very much but: >> I have not proper sorts in my PostgreSQL 8.1 database on my OpenBSD >> 4.0 >> server. >> I had set in /etc/profile the LC_COLLATE to pl_PL.ISO8859-2. >> The PostgreSQL cluster was created by command: >> initdb --locale=pl_PL.ISO8859-2 -E LATIN2 --lc-messages=C --lc- >> monetary=C >> --lc-numeric=C --lc-time=C -D /var/postgresql/data. >> >> I do not know is there possibility to fix this problem - maybe >> OpenBSD now >> support only C and POSIX collation ? > > If i understand you correctly, you're having trouble with how > Postgresql colates, not OpenBSD. you should consult the Postgresql > docs, starting with > > http://www.postgresql.org/docs/8.1/static/charset.html#AEN22133 > > >> >> Thanks for every help, >> best regards, >> Artur >> >> ps. sorry for my poor English >> > > Ben