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

Поиск
Список
Период
Сортировка
От Nico Grubert
Тема Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'
Дата
Msg-id 4364F1FD.6040102@arcor.de
обсуждение исходный текст
Ответы Re: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'  (Nico Grubert <nicogrubert@arcor.de>)
Список pgsql-general
Hi there,

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.

The SQL Query

   SELECT *
     FROM member
     WHERE name LIKE 'O%'
           OR
           name like 'Ö%'
     ORDER BY name


returns this:
  Öhlmann
  Öhmann
  Obenaus
  Ochoa
  O'Donovan
  Oehme
  Oklant
  Oltub
  Oltüch
  Oltutz
  Oltüwer

According to german sorting rules the result is fine except the both
first entries "Öhlmann" and "Öhmann".
Why do appear these records at the beginning of the list?
The proper result should read like this:
  Obenaus
  Ochoa
  O'Donovan
  Oehme
  Öhlmann
  Öhmann
  Oklant
  Oltub
  Oltüch
  Oltutz
  Oltüwer



The same problem accours when using "E" where my result is this:
   Élie de Beaumont
   Eberer
   Ecü
   Edding
   Emmer

The proper result should be:
   Eberer
   Ecü
   Edding
   Élie de Beaumont
   Emmer


Any idea how I can solve this problem?


Thank you very much in advance,
Nico

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Please HELP - URGENT - transaction wraparound error
Следующее
От: John Sidney-Woollett
Дата:
Сообщение: Re: Please HELP - URGENT - transaction wraparound error