Thread

PostgreSQL 7.1, UNICODE and glibc

Robert Gaszewski <graszew@poland.com> — 2001-04-01T22:54:03Z

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() get 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@poland.com