Yes, this is correct. SQL specification defines this behaviour.
On 2016.12.07. 14:24, Slavomir Skopalik wrote:
> Hi,
>
> is it correct that empty string '' in comparison with one space string '
> ' is evaluated as true?
>
> SELECT * FROM rdb$database WHERE ''=' '
>
> FB 2.5.6, database dialect 1
07.12.2016 16:24, Slavomir Skopalik wrote:
>
> is it correct that empty string '' in comparison with one space string '
> ' is evaluated as true?
Yes. Accordingly to the SQL standard, trailing spaces are ignored in
[most] comparisons.
Dmitry
07.12.2016 14:24, Slavomir Skopalik wrote:
> is it correct
Yes, it is correct according to collation definition.
--
WBR, SD.
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi
Hi,
is it correct that empty string '' in comparison with one space string '
' is evaluated as true?
SELECT * FROM rdb$database WHERE ''=' '
FB 2.5.6, database dialect 1
Slavek
--
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and