In FB2, FB2.5, FB3-Beta1, FB3-31661 it was possible to directly insert 50k long
text into blob field:
CREATE TABLE Tab (B BLOB SUB_TYPE TEXT);
INSERT INTO Tab (B) VALUES (' ... 50k ...');
However, in FB3-Beta2 and latest snapshot FB3-31925 it raises error
Dynamic SQL Error
-SQL error code = -104
-String literal with 50000 bytes exceeds the maximum length of 32765 bytes
I just hope it is just bug and not new limit :)
Ivan
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
