| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Robert Gaszewski <graszew(at)poland(dot)com> |
| Cc: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: LATIN2 and wrong upper() and lower() functions output |
| Date: | 2001-03-30 15:06:59 |
| Message-ID: | Pine.LNX.4.30.0103301705340.1063-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Robert Gaszewski writes:
> When I try SELECT UPPER('some_text_with_polish_national_chars');
> polish chars are still in lower case but others (abcd...wxyz) are
> in upper case.
> I compiled PostgreSQL with --enable-multibyte and
> --enable-unicode-conversion.
Case conversion and ordering are controlled by *locale*, not multibyte.
You need to configure with --enable-locale and set the appropriate LC_*
variables.
http://www.postgresql.org/devel-corner/docs/postgres/charset.html#LOCALE
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-03-30 15:52:52 | Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP |
| Previous Message | Peter Eisentraut | 2001-03-30 15:04:58 | Re: unix_socket_directory isn't used by all bin tools |