[Firebird-net-provider] Error inserting lage blobs

[Sam M. <sam...@cl...>]

I have a column defined as a BLOB SUB_TYPE TEXT
When I do an INSERT with a length of 736,174 bytes then an error is raised

the DB is created from:

Hashtable dbCreateParams = new Hashtable();
dbCreateParams.Add("Database", DatabaseName);
dbCreateParams.Add("User", UserName);
dbCreateParams.Add("Password", Password);
dbCreateParams.Add("Charset", "ASCII");
dbCreateParams.Add("Overwrite", "true");
dbCreateParams.Add("PageSize", "4096");
try
{
FbConnection.CreateDatabase(dbCreateParams);
}
catch (FbException e)
{
Parent.ReportError("Error creating FB database: " + e.Message);
}

but changing the PageSize seems to have no effect.

the table is created from:

cmd.CommandText = "create table Users (UserId bigint NOT NULL, XML blob
sub_type text NOT NULL, "+TimeColumn+" timestamp NOT NULL);";
cmd.ExecuteNonQuery();
// Create Index
cmd.CommandText = "CREATE UNIQUE INDEX IX_Users ON Users(UserId);";
cmd.ExecuteNonQuery();

I was a bit confused by the documentation on CreateDatabase with regard to
PageSize as it doesn't actually say what units it is in. I can quite believe
I am doing something silly here.

Any comments welcome

Thanks!

Sam