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

Reply via email to