Locale support on Mac OS X

Поиск
Список
Период
Сортировка
От Giorgio Valoti
Тема Locale support on Mac OS X
Дата
Msg-id 36126D18-8FB4-11D8-B106-00039398E21E@mac.com
обсуждение исходный текст
Ответы Re: Locale support on Mac OS X  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,
I'm trying to enable italian locale support on a Mac OS X host.
I run the initdb command with the following parameters (among others):
--encoding=UNICODE --locale=it_IT.UTF-8
then I created a new test database

test_locale=# \d test_sort
    Table "public.test_sort"
    Column   | Type | Modifiers
------------+------+-----------
  text_field | text |

test_locale=# select * from test_sort;
  text_field
------------
  a
  b
  c
  d
  e
  è
  é
  à
  A
(9 rows)

But the order by clause yields the wrong results

test_locale=# select * from test_sort order by text_field;
  text_field
------------
  A
  a
  b
  c
  d
  e
  à
  è
  é
(9 rows)

Further points:
- The sort command gives the same (wrong) results.
- GUI (Cocoa) applications give the expected sort.

Any clues? Should I assume that if sort does not give the expected
result, postgresql will not be different?

Thank you in advance


--
Giorgio Valoti
--------------

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

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: Mixed UTF8 / Latin1 database
Следующее
От: Shalu Gupta
Дата:
Сообщение: Accessing RelOptInfo structure from the executor module