Subject | Re: [firebird-support] Why is a blank not a blank? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-03-02T08:38:44Z |
Hi Mark,
--
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/
> On Fri, 02 Mar 2012 07:10:09 +0100, Thomas SteinmaurerThanks for the correction. ;-) The outcome is the same.
>> As expected. The equality operator removes trailing spaces before
>> evaluation. Use LIKE if you want to take trailing spaces into account.
>
> Comparison *adds* padding spaces to the shortest string to the length of
> the longest string to be compared.
--
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/