NULL in Blob fields

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
ale.capu
Posts: 10
Joined: Fri 21 Nov 2008 17:51

NULL in Blob fields

Post by ale.capu » Wed 17 Dec 2008 12:10

Hello,
I've a strange problem in release 4.x of dbxmda not present in 3.x.

I've a table with a BLOB field that can't be NULL.
Now if I insert a value with a parametrized query and load a parameter with this code:

MyDataSet.ParamByName('blob_field_name' ).LoadFromStream( MyStream, ftBlob );

Now, if MyStream is not empty no problem but if I've a empty stream (size=0) dbxmda 4.x whant to set blob field to NULL and not to empty stream ''. This problem is not present in dbxmda 3.x

Whaiting reply....
Best regards,
Alessandro

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 17 Dec 2008 14:29

I can not reproduce the problem.
Please send me a complete small sample at dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Post Reply