Devart Forums

In SQL Server, field type: bit discern TBooleanField in ADOQuery
In PostgreSQL, field type: bit discern TWideMemoField in ClientDataSet

So, I get the Error Message when write the field value in ClientDataSet.Post.
"Data rows "BIT_FIELD" type is bit, but expressions is type text."

Why?

Delphi XE5, 2009
DBX Driver version: 3.3.4

Hello,

For the time being, dbExpress doesn't support bit and bit varying types. To solve the problem, you should set the UnknownAsString option to true. We will consider the opportunity to support such types in one of the next versions.

So, Should I change the bit type change to char(1) or varchar(1).

It's right?

Hello,

The char(1) and varchar(1) types differ from the bit type, therefore the best solution will be to use the UnknownAsString option.

I hope can add this feature in the next version.

Because, dbexpress driver for sql server supported the bit type filed from Delphi 2009.

Hello,

This feature is in our operational plan, however, we cannot tell an exact feature implementation date.