| Subject | Re: [firebird-support] Comparison of Strings With Trailing White Spaces |
|---|---|
| Author | Ann Harrison |
| Post date | 2014-01-19T13:12:29Z |
> On Jan 18, 2014, at 7:38 PM, LtColRDSChauhan <rdsc1964@...> wrote:That's correct. The SQL standard states that when comparing strings of unequal length, the comparison shall be made as if the shorter string were padded with blanks to the length of the longer string.
>
> The under mentioned query outputs 1 (Firebird 3) :-
>
> select 1 from rdb$database where 'a' = 'a '
Good luck,
Ann