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
