Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: [GENERAL] Sorting problems with SELECT * FROM - Mailing list pgsql-general

From Daniel Verite
Subject Re: Re: [GENERAL] Sorting problems with SELECT * FROM
Date
Msg-id 20051031212937.8645272@localhost
Whole thread Raw
In response to Re: [GENERAL] Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'  (Nico Grubert <nicogrubert@arcor.de>)
List pgsql-general
Tree view 
    Nico Grubert wrote:

> Ah, I found it:
>
> lc_collate:     de_DE@euro
> lc_ctype:     de_DE@euro

This is an iso-8859-15 locale, isn't it?
If your database encoding is UNICODE, I believe you'd have more success
using an  UTF8 locale, such as de_DE.UTF-8 in your case.

--
 Daniel
 PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuuming strangeness
Next
From: Simon Riggs
Date:
Subject: Re: Partitioning attempts