Skip site navigation (1) Skip section navigation (2)

sorting order

From: Bertil Wergelius <Bertil(dot)Wergelius(at)telia(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: sorting order
Date: 2002-03-01 10:10:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I have worked with a lot of different DBMSs. Ranging from MSSQL over Sybase
SQL-anywhere to Interbase and most recently MySQL. With only the last mentioned
has there been no problem that my language is Swedish and that I therefore want
to use our own language's characters in correct sort order. MySQL gives a very
pleasant experience when it comes to character sets, collation orders and all
the rest; you don't have to care about it at all. That is perhaps because it is
a swedish product (of Sweden and Finland).
When I now start trying postgresql all the troubles with character sets come
back. I've changed LANG to sv_SE and LC_COLLATE too, (in sysconfig/i18n and 
restarted) created the database with encoding LATIN1, but nothing helps.
I can sort an ordinary textfile with cat textfile | sort. That sorts correctly 
so the collation must be correct, then why can't postgresql sort it correctly?


pgsql-novice by date

Next:From: Oliver ElphickDate: 2002-03-01 10:50:35
Subject: Re: sorting order
Previous:From: denisDate: 2002-03-01 05:34:08
Subject: Re: How does one determine which columns are constrained PRIMARY KEY?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group