Locale support on Mac OS X

From: Giorgio Valoti <giorgio_v(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Locale support on Mac OS X
Date: 2004-04-16 14:41:57
Message-ID: 36126D18-8FB4-11D8-B106-00039398E21E@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Lester 2004-04-16 15:01:25 Re: Optimal configuration to eliminate "out of file descriptors" error
Previous Message Jean-Michel POURE 2004-04-16 14:26:24 Re: Mixed UTF8 / Latin1 database