Re: locales and encodings on Windows

Lists: pgsql-hackers-win32
From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Thomas Kellerer" <spam_eater(at)gmx(dot)net>, <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: locales and encodings on Windows
Date: 2004-12-22 12:14:34
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE476431@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

> >> I have no idea, but I'm certain if someone is this is
> definitly not
> >> going to happen for 8.0.
> >
> >
> > I know this feature can't make it into 8.0; but blaming Windows for
> > more than one release cycle might not look very good. :-(
> >
>
> I'm not really experienced with the whole locale/character
> set topic, but what I'm wondering about (and I'm sure others
> will do as well) is, why other databases (such as Firebird or
> Oracle) do support UTF8/Unicode on the Windows platform but
> PostgreSQL does not.

PostgreSQL uses the OS functinos to do locale handling. The other
databases usually implement their own (or use a library that does it,
but they do not rely on the OS)

//Magnus


From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: locales and encodings on Windows
Date: 2004-12-22 16:26:47
Message-ID: cqc787$fgdcqc787$fgd$1@sea.gmane.org@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

Magnus Hagander wrote on 22.12.2004 13:14:
> [about PG not supporting Unicode on Windows]
>
> PostgreSQL uses the OS functinos to do locale handling. The other
> databases usually implement their own (or use a library that does it,
> but they do not rely on the OS)

Being a developer myself I can understand this reason, but in the PG
context I'm a User I not having Unicode support is my eyes a very big
deficiency which gives the whole Win32 a semi-professional "touch".

Unicode is something very important and I do hope this will be solved in on
of the next releases.

Cheers
Thomas

P.S.: don't get me wrong: the Win32 is *very* much appreciated.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: locales and encodings on Windows
Date: 2004-12-22 17:21:47
Message-ID: 5149.1103736107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> Magnus Hagander wrote on 22.12.2004 13:14:
>>> [about PG not supporting Unicode on Windows]
>>
>> PostgreSQL uses the OS functinos to do locale handling. The other
>> databases usually implement their own (or use a library that does it,
>> but they do not rely on the OS)

> Being a developer myself I can understand this reason, but in the PG
> context I'm a User I not having Unicode support is my eyes a very big
> deficiency which gives the whole Win32 a semi-professional "touch".

> Unicode is something very important and I do hope this will be solved in on
> of the next releases.

[ shrug... ] It can't be too important to Windows users, since their
platform doesn't support it.

regards, tom lane


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: locales and encodings on Windows
Date: 2004-12-22 17:25:41
Message-ID: 200412221725.iBMHPfQ25609@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

Tom Lane wrote:
> Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> > Magnus Hagander wrote on 22.12.2004 13:14:
> >>> [about PG not supporting Unicode on Windows]
> >>
> >> PostgreSQL uses the OS functinos to do locale handling. The other
> >> databases usually implement their own (or use a library that does it,
> >> but they do not rely on the OS)
>
> > Being a developer myself I can understand this reason, but in the PG
> > context I'm a User I not having Unicode support is my eyes a very big
> > deficiency which gives the whole Win32 a semi-professional "touch".
>
> > Unicode is something very important and I do hope this will be solved in on
> > of the next releases.
>
> [ shrug... ] It can't be too important to Windows users, since their
> platform doesn't support it.

And what solution options do we have? Is bundling our own Unicode
library something we even want to consider? I would think not.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: locales and encodings on Windows
Date: 2004-12-22 17:28:03
Message-ID: 200412221728.iBMHS3I25886@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

Bruce Momjian wrote:
> Tom Lane wrote:
> > Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> > > Magnus Hagander wrote on 22.12.2004 13:14:
> > >>> [about PG not supporting Unicode on Windows]
> > >>
> > >> PostgreSQL uses the OS functinos to do locale handling. The other
> > >> databases usually implement their own (or use a library that does it,
> > >> but they do not rely on the OS)
> >
> > > Being a developer myself I can understand this reason, but in the PG
> > > context I'm a User I not having Unicode support is my eyes a very big
> > > deficiency which gives the whole Win32 a semi-professional "touch".
> >
> > > Unicode is something very important and I do hope this will be solved in on
> > > of the next releases.
> >
> > [ shrug... ] It can't be too important to Windows users, since their
> > platform doesn't support it.
>
> And what solution options do we have? Is bundling our own Unicode
> library something we even want to consider? I would think not.

If the Win32 Unicode implemetation is buggy, can we work around the bugs
in our code?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073