Memo fields returned as Blob

Memo fields returned as Blob

Postby Sieg » Tue 08 Apr 2008 14:44


I'm currently evaluating CoreLab dbExpress drivers for usage in a database independent application server.

So far it's looking good, however I encountered a bug today. While the readme explicitly states that binary blobs are mapped to ftBlob (TBlobField) and text blobs to ftMemo (TMemoField), it seems that BLOB SUB_TYPE 1 fields are still mapped to TBlobField. The server is Firebird 1.5.4. It may not be important, but the field is defined using a domain.

Is it a known issue or am I doing something wrong?

Thanks in advance.

EDIT: Forgot to mention that I'm using CodeGear RAD Studio (december patch applied)
Posts: 3
Joined: Tue 08 Apr 2008 14:26

Postby Plash » Wed 09 Apr 2008 07:18

This is a bug. We'll add the fix in the next build of DbxIda.
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby HK » Wed 16 Apr 2008 20:04

The same problem occurs if you use a TEXT in SQL Server 2005, and not create a Field in SQLDataSet. The message is SYSTEM CLASH .. Cannot save varbinary as text ...
Posts: 12
Joined: Tue 14 Nov 2006 13:30

Postby Antaeus » Mon 21 Apr 2008 06:50

Could you send us a complete small sample to dbxsda*crlab*com to demonstrate the problem with DbxSda?

Also supply me the following information:
- script to create and fill table used in the sample;
- exact version of DbxSda.
- exact version of SQL server and client.
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Postby HK » Mon 05 May 2008 13:14

Sorry for delay friend. I will send a sample application ASAP, but you can test trying to copy the TEXT field to another in SQL Server 2005 , without use a defined field for that .

Posts: 12
Joined: Tue 14 Nov 2006 13:30

Return to dbExpress driver for InterBase & Firebird