| 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: | Whole Thread | Raw Message | 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) |