| Subject | Trailing spaces behaviour |
|---|---|
| Author | Alexander Tabakov |
| Post date | 2018-03-20T14:34:24Z |
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 :)
WBR, Alex