PostgreSQL field type: bit discern TWideMemoField

PostgreSQL field type: bit discern TWideMemoField

Postby Eden0928 » Sat 09 Nov 2013 00:48

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
Eden0928
 
Posts: 44
Joined: Sun 22 Apr 2012 14:08

Re: PostgreSQL field type: bit discern TWideMemoField

Postby AlexP » Mon 11 Nov 2013 14:35

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.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL field type: bit discern TWideMemoField

Postby Eden0928 » Mon 11 Nov 2013 16:01

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

It's right?
Eden0928
 
Posts: 44
Joined: Sun 22 Apr 2012 14:08

Re: PostgreSQL field type: bit discern TWideMemoField

Postby AlexP » Mon 11 Nov 2013 16:43

Hello,

The char(1) and varchar(1) types differ from the bit type, therefore the best solution will be to use the UnknownAsString option.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL field type: bit discern TWideMemoField

Postby Eden0928 » Tue 12 Nov 2013 03:12

I hope can add this feature in the next version.

Because, dbexpress driver for sql server supported the bit type filed from Delphi 2009.
Eden0928
 
Posts: 44
Joined: Sun 22 Apr 2012 14:08

Re: PostgreSQL field type: bit discern TWideMemoField

Postby AlexP » Tue 12 Nov 2013 06:45

Hello,

This feature is in our operational plan, however, we cannot tell an exact feature implementation date.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for PostgreSQL