PostgreSQL 7.1, UNICODE and glibc

From: Robert Gaszewski <graszew(at)poland(dot)com>
To: PGSQL-GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 7.1, UNICODE and glibc
Date: 2001-04-02 11:27:14
Message-ID: 3AC86212.8CEBF16F@poland.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to use PostgreSQL 7.1 with encoding set to UNICODE
and polish sorting.
Therefore I'd like to know which version of glibc and
locales works properly with UNICODE.

I have Debian GNU/Linux 2.2 "Potato" with glibc 2.1 and with
this version PostgreSQL works improperly.

It looks PostgreSQL doesn't know how to sort rows (ORDER BY
works improperly)
Also upper() and lower() return bad results.
for example when I try SELECT
UPPER('some_text_with_polish_chars') polish chars are still
in lower case
but others(abc...xyz) are in upper case.

I set locale in this way:
LANG=pl_PL
LC_CTYPE=pl_PL
LC_COLLATION=pl_PL
LC_MONETARY=pl_PL

(maybe they shouldb be set to pl_PL.UTF-8 instead of pl_PL
but my glibc doesn't support pl_PL.UTF-8)

How to solve this problem? Which version of glibc is
required?

PS.
I have PostgreSQL 7.1RC1 compiled with --enable-multibyte
--enable-unicode-convesion --enable-locale
Then initdb -E UNICODE -D /usr/local/pgsql/data

Greetings,
Robert

------------------
Robert Gaszewski
graszew(at)poland(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Einar Karttunen 2001-04-02 11:32:38 User identification (external/internal)
Previous Message Joseph 2001-04-02 10:51:18 Log file to sql database