Package: postgresql-8.2
Version: 8.2.4-1
Severity: normal
When I try to use upper(), lower(), or ILIKE on UNICODE databases results
are incorrect. For example:
testy-utf=# select upper('Żółć'), lower('Żółć');
upper | lower
-------+-------
ūãłć |
(1 row)
And now the same thing on database with LATIN2 encoding (here we have correct
results):
testy=# select upper('Żółć'), lower('Żółć');
upper | lower
-------+-------
ŻÓŁĆ | żółć
(1 row)
I have the same problem when using psql command line utility, and pgadmin3 and
JDBC driver.
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.18-4-686 (SMP w/1 CPU core)
Locale: LANG=pl_PL.UTF-8, LC_CTYPE=pl_PL.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages postgresql-8.2 depends on:
ii libc6 2.5-5 GNU C Library: Shared libraries
ii libcomer 1.39+1.40-WIP-2007.04.07+dfsg-2 common error description library
ii libkrb53 1.6.dfsg.1-2 MIT Kerberos runtime libraries
ii libpam0g 0.79-3.2 Pluggable Authentication Modules l
ii libpq5 8.2.4-1 PostgreSQL C client library
ii libssl0. 0.9.8e-4 SSL shared libraries
ii postgres 8.2.4-1 front-end programs for PostgreSQL
ii postgres 75 manager for PostgreSQL database cl
ii tzdata 2007f-1 time zone and daylight-saving time
postgresql-8.2 recommends no packages.
-- no debconf information
