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
PostgreSQL field type: bit discern TWideMemoField
Re: PostgreSQL field type: bit discern TWideMemoField
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.
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.
Re: PostgreSQL field type: bit discern TWideMemoField
So, Should I change the bit type change to char(1) or varchar(1).
It's right?
It's right?
Re: PostgreSQL field type: bit discern TWideMemoField
Hello,
The char(1) and varchar(1) types differ from the bit type, therefore the best solution will be to use the UnknownAsString option.
The char(1) and varchar(1) types differ from the bit type, therefore the best solution will be to use the UnknownAsString option.
Re: PostgreSQL field type: bit discern TWideMemoField
I hope can add this feature in the next version.
Because, dbexpress driver for sql server supported the bit type filed from Delphi 2009.
Because, dbexpress driver for sql server supported the bit type filed from Delphi 2009.
Re: PostgreSQL field type: bit discern TWideMemoField
Hello,
This feature is in our operational plan, however, we cannot tell an exact feature implementation date.
This feature is in our operational plan, however, we cannot tell an exact feature implementation date.