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

[Tom Lane <tgl@xxxxxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org