How do I map the FireBird type BLOB SUB_TYPE 1 SEGMENT SIZE 500?

Jul 14, 2008 at 11:20 AM

I'm writing my Dataobject classes and I have a question about the FireBird datatye BLOB.

What is the correct Datatype I have to use to map a dbcolum of a Firebird 2.1 db with the datatype BLOB SUB_TYPE 1 SEGMENT SIZE 500?

Jul 14, 2008 at 1:58 PM
Edited Jul 14, 2008 at 1:59 PM
I think it should be:

[ Length(500) ]
public abstract byte[] BinData { get; set; }

But I was not used blob in my projects so it's not fully tested.
I think you should create table by use SQL.
Hope you can tell me if it works or not.
Jul 20, 2008 at 8:11 PM

I found something inside your Firebird Dialect class.

public class Firebird : SequencedDialect
        public Firebird()
            TypeNames[DataType.String] = "BLOB SUB_TYPE 1";

So I used string without the Length attribute and it works :)

Jul 21, 2008 at 4:22 AM
Yes, I just found "BLOB SUB_TYPE 1" means text string...
Glad it works for you.