Skip site navigation (1) Skip section navigation (2)

Bug in functions lower(), upper() with SQL_ASCII and LATIN1?

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 (view raw or flat)
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)



Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-05-06 17:43:15
Subject: Bug #658: psql does not start on cygwin
Previous:From: pgsql-bugsDate: 2002-05-06 06:00:59
Subject: Bug #657: VB DAO MoveFirst/MoveLast become invalid operation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group