Re: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nico Grubert <nicogrubert(at)arcor(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'
Date: 2005-10-30 16:31:43
Message-ID: 7660.1130689903@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nico Grubert <nicogrubert(at)arcor(dot)de> writes:
> I have a problem when sorting records with:
> SELECT * FROM table WHERE name LIKE '%'

> I am running Postgres 8.02 with a database whose character encoding is
> UNICODE.

... but what locale is it using? (See LC_COLLATE and LC_CTYPE.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-30 16:34:47 Re: Please HELP - URGENT - transaction wraparound error
Previous Message John Sidney-Woollett 2005-10-30 16:24:08 Re: Please HELP - URGENT - transaction wraparound error