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?
