Received: from bastuba.partitur.se ([212.209.169.194]) by hub.org (8.10.1/8.10.1) with ESMTP id e8BDpYX83417; Mon, 11 Sep 2000 09:51:34 -0400 (EDT) Received: from elbas.partitur.se (elbas.partitur.se [212.209.169.222]) by bastuba.partitur.se (8.9.3/8.9.3) with ESMTP id PAA47630; Mon, 11 Sep 2000 15:51:26 +0200 (CEST) (envelope-from girgen@partitur.se) Received: from partitur.se (localhost.partitur.se [127.0.0.1]) by elbas.partitur.se (8.9.3/8.9.3) with ESMTP id PAA71160; Mon, 11 Sep 2000 15:51:24 +0200 (CEST) (envelope-from girgen@partitur.se) Message-ID: <39BCE35B.CE42BDBC@partitur.se> Date: Mon, 11 Sep 2000 15:51:23 +0200 From: Palle Girgensohn Organization: Partitur X-Mailer: Mozilla 4.75 [en] (X11; U; FreeBSD 4.0-STABLE i386) X-Accept-Language: sv, en MIME-Version: 1.0 To: Oleg Bartunov CC: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: need asap: bg_BG locale for FreeBSD References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/65 Oleg Bartunov wrote: > > Hi, > > I'm going to Bulgaria this week to setup FreeBSD server running > postgres and would like to know if somebody has an experience > with postgres and bulgarian locale. Actually, I need > bg_BG locale for FreeBSD. interesting that searching for > subject in internet doesn't provide any information. > The only thing I found is bg_BG locale for Linux (Redhat) I created a Swedish LC_COLLATE locale part for FreeBSD a while back, with the specific purpose of using it with PostgreSQL, and it was not very hard. For sorting stuff: Check /usr/src/share/colldef (the sorting algoritm is defined by LC_COLLATE). I don't anything about bulgarian, though. Is it using cyrillic characters? Try using one of the russion locales to start with. For character representation (LC_CTYPE), I have no experience, but it should also be fairly easy. Maybe Bulgarian uses a similar character set to for example Russian? You will only need a character locale for each Check /usr/src/share/mklocale For a complete locale, you would also need timedef (/usr/src/share/timedef). colldef(1) is man page to check for sorting (collate)... mklocale(1) is for locale creation. Good luck! Palle