Louis,

Maybe is what I do to simple for you, but I use a blob like this:

CREATE DOMAIN DOMTEXT AS BLOB SUB_TYPE TEXT SEGMENT SIZE 128;

And than I use AsString to store the text:

sql.FieldByName('BLOB_COL').AsString := Memo.Text;

I use IBX sql components.

Cheers,

Henk.