Hello,

i have a table with a field F1 sized VARCHAR(1).

Some values are '' (field is empty).

Astonishing following SQLs produce the same result:

select * from test t where t.f1=''

or

select * from test t where t.f1=' '

or

select * from test t where t.f1=' '

No matter how many spaces i insert into the sql, the result presents all datasets where field is empty.

I testet this with several databases and several Firebird versions: 1.5, 2.1 and 2.5 (all 32 bit). Result is allways the same.

In my oppinion this is a bug, isnt it? Only the first SQL shoud return the datasets, where F1 is empty. Or am i wrong?