pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
need asap: bg_BG locale for FreeBSD
3+ messages / 2 participants
[nested] [flat]

* need asap: bg_BG locale for FreeBSD
@ 2000-09-11 07:40  Oleg Bartunov <oleg@sai.msu.su>
  0 siblings, 1 reply; 3+ messages in thread

From: Oleg Bartunov @ 2000-09-11 07:40 UTC (permalink / raw)
  To: pgsql-hackers@postgresql.org; +Cc: pgsql-sql

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)

	Regards,

		Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: need asap: bg_BG locale for FreeBSD
@ 2000-09-11 13:51  Palle Girgensohn <girgen@partitur.se>
  parent: Oleg Bartunov <oleg@sai.msu.su>
  0 siblings, 1 reply; 3+ messages in thread

From: Palle Girgensohn @ 2000-09-11 13:51 UTC (permalink / raw)
  To: Oleg Bartunov <oleg@sai.msu.su>; +Cc: pgsql-hackers@postgresql.org; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: need asap: bg_BG locale for FreeBSD
@ 2000-09-11 14:32  Oleg Bartunov <oleg@sai.msu.su>
  parent: Palle Girgensohn <girgen@partitur.se>
  0 siblings, 0 replies; 3+ messages in thread

From: Oleg Bartunov @ 2000-09-11 14:32 UTC (permalink / raw)
  To: Palle Girgensohn <girgen@partitur.se>; +Cc: pgsql-hackers@postgresql.org; pgsql-sql

Palle,

thanks for the message. I've created bulgarian locale
from similar russian sources (I believe it's CP1251 charset).
Hope it would be ok.

	Regards,
		Oleg

On Mon, 11 Sep 2000, Palle Girgensohn wrote:

> Date: Mon, 11 Sep 2000 15:51:23 +0200
> From: Palle Girgensohn <girgen@partitur.se>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org
> Subject: Re: [SQL] need asap: bg_BG locale for FreeBSD
> 
> 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
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-09-11 14:32 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-11 07:40 need asap: bg_BG locale for FreeBSD Oleg Bartunov <oleg@sai.msu.su>
2000-09-11 13:51 ` Palle Girgensohn <girgen@partitur.se>
2000-09-11 14:32   ` Oleg Bartunov <oleg@sai.msu.su>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox