Very interesting discussion indeed.
It seems that "Postgresql:The world's most advanced open source database" can
not work properly on "Mac OS X: the world's most advanced operating system" and
FreeBSD.
Don't you think postgresql.org should remove from their download page the links
to FreeBSD
On Sat, Jan 16, 2010 at 09:10:53PM +, Greg Stark wrote:
> Switching to ICU means trading our current inconsistency from platform
> to platform for a different inconsistency which would be better in
> some cases and worse in others.
Or, you can have the cake and eat it too. That is, aim for the
On Thu, Jan 14, 2010 at 6:15 AM, Craig Ringer
wrote:
>>> Out of interest: Why not?
>>
>> There's plenty of discussion in the archives about it, but basically
>> ICU would represent a pretty enormous dependency and would lock us in
>> to having no other backend encoding but UTF8.
>
> Thanks. You're
Scott Marlowe wrote:
> On Wed, Jan 13, 2010 at 11:15 PM, Craig Ringer
> wrote:
>> Perhaps someone who wants to use Mac OS X and Pg for their product will
>> come forward with some compat wrapper functions for the localizable
>> libc/posix functions, so Pg can just be built against the wrapper and
Craig Ringer writes:
> Tom Lane wrote:
>> The state of OS X's POSIX-spec locale support is pretty pitiful, but on
>> the whole I'd say if you need better UTF8 locale support you could use
>> another OS.
> Alas, people will want to run Pg on it anyway, especially when bundling
> with an app. It'd
On Wed, Jan 13, 2010 at 11:15 PM, Craig Ringer
wrote:
> Perhaps someone who wants to use Mac OS X and Pg for their product will
> come forward with some compat wrapper functions for the localizable
> libc/posix functions, so Pg can just be built against the wrapper and
> the rest of us need not ca
Tom Lane wrote:
> Craig Ringer writes:
>> Martijn van Oosterhout wrote:
>>> Yes, that's the basic idea. Mac OS X apparently provides ICU underneath
>>> for programs that would like true unicode collation, but there is
>>> little chance that postgresql will ever use this.
>
>> Out of interest: Why
Craig Ringer writes:
> Martijn van Oosterhout wrote:
>> Yes, that's the basic idea. Mac OS X apparently provides ICU underneath
>> for programs that would like true unicode collation, but there is
>> little chance that postgresql will ever use this.
> Out of interest: Why not?
There's plenty of
Martijn van Oosterhout wrote:
>> in a UTF8 text file and use the "sort" command on it, you will have the same
>> wrong output as with PostgreSQL :
>
> Yes, that's the basic idea. Mac OS X apparently provides ICU underneath
> for programs that would like true unicode collation, but there is
> lit
On 13/01/2010 11:15 PM, Martin Flahault wrote:
It seems there is a problem with the collating order on BSD systems with
diacritics using UTF8.
If you put this text :
a
A
à
é
e
E
in a UTF8 text file and use the "sort" command on it, you will have the
same wrong output as with PostgreSQL :
A
E
a
On Wed, Jan 13, 2010 at 04:15:06PM +0100, Martin Flahault wrote:
[postgres]
> newbase=# select * from t1 order by contenu;
> contenu
> -
> A
> E
> a
> e
Postgresql outputs whatever the C library does on the underlying
system. The quality of this varies wildly.
> à
> As with others
Here is an exemple :
postgres=# create database newbase;
CREATE DATABASE
postgres=# \c newbase;
psql (8.4.2)
You are now connected to database "newbase".
newbase=# create table t1 (contenu text);
CREATE TABLE
newbase=# insert into t1 values ('a'), ('e'), ('à'), ('é'), ('A'), ('E');
INSERT 0 6
ne
On 12/01/2010 7:36 PM, Martin Flahault wrote:
Hi,
We are a software publisher searching for a new DBMS for our software.
We have more than one hundred installed servers, running Mac OS and a
Primebase database.
We have spend some time evaluating PostgreSQL and we can't get correct
outputs with
Am 12.01.2010 um 12:36 schrieb Martin Flahault:
> We have spend some time evaluating PostgreSQL and we can't get correct
> outputs with the ORDER BY command.
> LC_COLLATE and LC_CTYPE are set to fr_FR.UTF-8.
>
> It seems there is a known problem with the collating order of text including
> diac
Hi,
We are a software publisher searching for a new DBMS for our software. We have
more than one hundred installed servers, running Mac OS and a Primebase
database.
We have spend some time evaluating PostgreSQL and we can't get correct outputs
with the ORDER BY command.
LC_COLLATE and LC_CTYPE
15 matches
Mail list logo
