PostgreSQL field type: bit discern TWideMemoField

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Eden0928
Posts: 47
Joined: Sun 22 Apr 2012 14:08

PostgreSQL field type: bit discern TWideMemoField

Post by 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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL field type: bit discern TWideMemoField

Post by 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.

Eden0928
Posts: 47
Joined: Sun 22 Apr 2012 14:08

Re: PostgreSQL field type: bit discern TWideMemoField

Post by Eden0928 » Mon 11 Nov 2013 16:01

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

It's right?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL field type: bit discern TWideMemoField

Post by 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.

Eden0928
Posts: 47
Joined: Sun 22 Apr 2012 14:08

Re: PostgreSQL field type: bit discern TWideMemoField

Post by 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.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL field type: bit discern TWideMemoField

Post by AlexP » Tue 12 Nov 2013 06:45

Hello,

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

Post Reply