> try the following code:
>
> create exception test 'Blank';
> set term ^;
> create OR alter procedure p_test
> as
> begin
> IF (' ' = '') THEN
> exception test;
> end^
> set term ;^
> execute procedure p_test;
>
> Upon execution the exception is raised. So Firebird is saying that a blank is
> the same as no blank.
> We are not talking about trimming of chars or varchars here. These are
> constants. Surely this can't be the desired outcome...
As expected. The equality operator removes trailing spaces before
evaluation. Use LIKE if you want to take trailing spaces into account.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/
