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 --------------

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to