PostgreSQL, UTF-8 and Mac OS X

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL, UTF-8 and Mac OS X
Date: 2005-11-07 11:50:18
Message-ID: 59921EB4-394D-4216-990D-4906567BDDB6@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I have a problem with PostgreSQL and UTF-8 on my Mac OS X Powerbook.

- System is Mac OS X Client 10.4.3, PostgreSQL 8.1beta3

- initdb was called with -E UTF-8 --locale=de_DE.UTF-8

I have successfully build a LC_COLLATE file for ISO8859-15, and
ordering works there if I do the initdb with ISO8859-1 but I want to
use UTF-8 for some reasons.

I have linked the LC_COLLATE for de_DE.UTF-8 to the same LC_COLLATE
file that works fine with ISO8859-1.

"show all;" shows that the encoding ist UTF-8 now, the LC_... are
"de_DE.UTF-8". Okay, this is fine.

But it doesn't work. The LC_COLLATE file works, if I set encoding and
locale to ISO... but not, if I set the values to be UTF-8 (don't know
how often I have called initdb in the last days ...).

It seems to me, that the locale "de_DE.UTF-8" just isn't working at
all (at least for ordering results) in the combination PG -- Mac OS X.

Some hints what I can try to find out more?

cug

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Filipov 2005-11-07 12:09:40 Re: I just can't get it:record_in, record_out(I know i try to do something postgres is not developed for but there are many 'buts')
Previous Message ctobini 2005-11-07 11:15:21 Recuperate each line of a result into a variable ?