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

Nico Grubert <nicogrubert@arcor.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