Zeoslib Portal

As of Zeos 6.6.2rc, blobs are saved in SQLite 3 as string with a custom escaping. This is not per SQLite 3 specification, that recommends the X'0123456789ABCDEF' SQL standard notation for blobs. Saving data with this format switches the field data type to blob instead of string, and is more efficien...

The SQL-92 standard defines the "DOUBLE PRECISION" data type and an optional precision parameter for the "FLOAT(precision)" data type (edit: I've just seen the latter is already addressed). The SQLite definition accommodates to this, the current Zeos implementation (as of 6.6.2rc...

The fix is the one proposed by the original poster. And, just to clarify, I've already it in my working copy for some time and I'm fine with it. You may sandwich it in IFDEFs or using some runtime parameter. The point is: the current convention does not allow to formulate generic SQL, but enforce 'Y...

I'm afraid I've not explained clearly enough. There is no problem with the way the VCL interacts with "booleans" with either definition, there is no need for StrToBool and BoolToStr here. This is true as long as Delphi and the VCL are your only reference environment, and that you code for ...

In SQLite SELECT * FROM my_table WHERE my_bool_column and SELECT * FROM my_table WHERE NOT my_bool_column don't work with the current Zeos approach of 'Y/N' (nor 'true/false' for the matter). 0/1 is needed for this. This is also consistent with other DBMSs such as Postgres and MySQL. Please consider...