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
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) |