weird lower() problem with character
От | Björn Metzdorf |
---|---|
Тема | weird lower() problem with character |
Дата | |
Msg-id | 001a01c2c3d9$8698de00$81c206d4@office.turtleentertainment.de обсуждение исходный текст |
Ответы |
Re: weird lower() problem with character
|
Список | 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@test.com'); INSERT 12016215 1 test=> select * from test where test = lower('TEST@TEST.COM'); test --------------- test@test.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@test.com'); INSERT 12016228 1 test=> select * from test where test = lower('TEST@TEST.COM'); test ------ (0 rows) ============================================================== Comments? How can I fix that without converting to varchar? Regards, Bjoern
В списке pgsql-general по дате отправления: