Alex,
> Hi All,
>
> I have found strange behaviour concerning trailing spaces - following
> strings are equal:
>
> 'ABC ' = 'ABC'
>
> You can try the following query:
>
> /select/
> / case when 'ABC ' = 'ABC' then 1 else 0 end,/
> / case when cast('ABC ' as varchar(10)) = cast('ABC' as varchar(10))
> then 1 else 0 end,/
> / char_length('ABC '),/
> / char_length('ABC')/
> /from/
> / rdb$database/
>
> This query was tested on FB v.1.5.6, 2.5.8 & 3.0.3 - while char length
> (or strlen on 1.5) is different, the strings are always equal.
>
> Is this by design :)
Additionally to Dimitry's reply.
If you need a reliable way for comparison and want to treat trailing
spaces as different, check out the IS [NOT] DISTINCT FROM clause.
https://firebirdsql.org/refdocs/langrefupd21-distinct.html
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
