Re: [Firebird-devel] FB2.5.6 - '' = ' ' is evaluated as true

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

Re: [Firebird-devel] FB2.5.6 - '' = ' ' is evaluated as true

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

Re: [Firebird-devel] FB2.5.6 - '' = ' ' is evaluated as true

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

[Firebird-devel] FB2.5.6 - '' = ' ' is evaluated as true

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

[Firebird-devel] IBX2 is now available with full support for the FIrebird 3 API

For those interested in using Firebird from Pascal/Lazarus, I've copied the following announcement to this list. Tony Whyman MWA Software Announcement follows: MWA Software is pleased to announce the release of IBX2 for Lazarus. This is formally a pre-release. Although the software has been