Postgres Pro
Downloads
Home   >   mailing lists

Re: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%' - Mailing list pgsql-general

From Tom Lane
Subject Re: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'
Date
Msg-id 7660.1130689903@sss.pgh.pa.us
Whole thread Raw
In response to Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'  (Nico Grubert <nicogrubert@arcor.de>)
Responses Re: [GENERAL] Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'
Re: [GENERAL] Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: mysql replace in postgreSQL?
Next
From: Tom Lane
Date:
Subject: Re: Please HELP - URGENT - transaction wraparound error