> From: Claudio Valderrama C. > > -----Original Message----- > > From: Ivan Pøenosil [mailto:[email protected]] > > Sent: Martes, 07 de Julio de 2015 18:10 > > > > 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 > > Ivan, > considering your expertise with IB/FB, I hope my comment won't appear to you > as an insult:
Of course not :) > I assume you verified that such command in FB2.1 really stored 50k in the > blob. > ;-) I use it for years. It was new feature in FB1.5 I use it e.g. for storing statements for report generator, sometimes they are big Execute Statements, so if it was not stored correctly, I would noticed immediately :-) > Was the string a parameter? I can't imagine a literal because there's a > limit for the SQL command you can pass to the server. No, just pure insert/update statements passed directly to FB. Of course statements are always <64k, but the "blob-string" can be >32k 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
