what driver are you using ? DAL creates 'blob' fields as BLOB TYPE 1....
can you please check that the field is created indeed as BLOB TYPE 1
watching your databases/sql.log file ?
This is an excerpt from firebird documentation
*Sub-type is 1.** *
*This blob field sub-type is designed for the storage and manipulation of
text. Typically, this is free-form memo or notes data. Typically you would
use this blob field sub-type is for storing large amounts of text data.
This is more convenient that a large VARCHAR because, unlike a VARCHAR,
there is no 32K limit.*
On Monday, July 1, 2013 7:21:03 PM UTC+2, Raul Monares wrote:
>
> When trying to store a value greater than 64k in a Blob Field, I get this
> error:
>
> <class 'fdb.fbcore.DatabaseError'> ('Error while preparing SQL
> statement:\n- SQLCODE: -104\n- Dynamic SQL Error\n- SQL error code =
> -104\n- Unexpected end of command - line 1, column 25', -104, 335544569)
> But with blobs smaller than 64k works fine.
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
