From: | Hans Plum <plum(at)giub(dot)uni-bonn(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug in functions lower(), upper() with SQL_ASCII and LATIN1? |
Date: | 2002-05-06 16:50:14 |
Message-ID: | 3CD6B446.70408@giub.uni-bonn.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello PostgreSQL Developers,
I could not find a bug report to the functions lower() and upper() on
the todo-list.
Hopefully it is one, so that you are not bored by old tasks ...
Take a look at the code and the reactions of PostgreSQL: When I try to
convert german umlaute, e.g. Ä,Ö,Ü with lower(), I get no lower letters.
With upper() it is the same problem vice verser ...
All the best from Germany,
Hans
ghl=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)
ghl=# create DATABASE sql_ascii;
CREATE DATABASE
ghl=# \l
List of databases
Database | Owner | Encoding
-----------+----------+-----------
sql_ascii | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(6 rows)
ghl=# \c sql_ascii
You are now connected to database sql_ascii.
sql_ascii=# select lower('OAU');
lower
-------
oau
(1 row)
sql_ascii=# select lower('ÖÄÜ');
lower
-------
ÖÄÜ
(1 row)
---------------------------------------------------------------------
sql_ascii=# CREATE DATABASE latin1 WITH ENCODING = 'latin1';
CREATE DATABASE
sql_ascii=# \l
List of databases
Database | Owner | Encoding
-----------+----------+-----------
latin1 | postgres | LATIN1
sql_ascii | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(7 rows)
latin1=# select lower('OAU');
lower
-------
oau
(1 row)
latin1=# select lower('ÖÄÜ');
lower
-------
ÖÄÜ
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-05-06 17:43:15 | Bug #658: psql does not start on cygwin |
Previous Message | pgsql-bugs | 2002-05-06 06:00:59 | Bug #657: VB DAO MoveFirst/MoveLast become invalid operation |