weird lower() problem with character

From: Björn Metzdorf <bm(at)turtle-entertainment(dot)de>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: weird lower() problem with character
Date: 2003-01-24 18:50:55
Message-ID: 001a01c2c3d9$8698de00$81c206d4@office.turtleentertainment.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

it seems that something has changed in handling 'character' datatypes.

With 7.2.3 this worked fine, with 7.3.1 it does not work.

This is a test with varchar, and it works:
==============================================================
test=> create table test ( test varchar(200) );
CREATE TABLE
test=> insert into test values ('test(at)test(dot)com');
INSERT 12016215 1
test=> select * from test where test = lower('TEST(at)TEST(dot)COM');
test
---------------
test(at)test(dot)com
(1 row)
==============================================================

with 'character' it does not work anymore:
==============================================================
test=> create table test ( test character(200) );
CREATE TABLE
test=> insert into test values ('test(at)test(dot)com');
INSERT 12016228 1
test=> select * from test where test = lower('TEST(at)TEST(dot)COM');
test
------
(0 rows)
==============================================================

Comments? How can I fix that without converting to varchar?

Regards,
Bjoern

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-01-24 19:13:53 Re: More PHP DB abstraction layer stuff
Previous Message Mikhail Terekhov 2003-01-24 18:17:13 Re: OT: cvsweb (was: psql 7.3.1 crash)