On 02.11.2005, at 11:47 Uhr, Martijn van Oosterhout wrote:
Ah you noticed that. Yes, many of the UTF-8 locales in FreeBSD simply
point to the ASCII versions which doesn't exactly work very well.
Right.
Only another FreeBSD system, these files are not portable. However,
the
source files for
On Wed, Nov 02, 2005 at 07:27:49AM +0100, Guido Neitzer wrote:
> The LC_COLLATE for this locale is a link pointing to "../la_LN.US-
> ASCII/LC_COLLATE". This is why I don't think they paid much attention
> to the correct sort order of umlauts.
Ah you noticed that. Yes, many of the UTF-8 locales
On 01.11.2005, at 23:24 Uhr, Martijn van Oosterhout wrote:
PostgreSQL should get the same results as the command-line sort for
the
same values of LC_COLLATE. However, the value is fixed at initdb time
so maybe that's what's confusing you.
Yes, it gets the same results as sort.
I have tried
On Tue, Nov 01, 2005 at 10:56:02PM +0100, Guido Neitzer wrote:
> Hi.
>
> I have a problem with the use of PostgreSQL on Mac OS X (10.4.x) and
> selects with "order by". When there are german umlauts in the column
> which is used to order, the sorted result is wrong.
PostgreSQL should get the