At 06:59 p.m. 21/09/2015, Dmitry Yemanov wrote: >21.09.2015 09:08, Simonov Denis wrote: > >>> 1. Can a string literal really be 64Kb if, internally, it is converted >>> to varchar? > >Yes, it can. Internally our varchars allow strings up to 64KB, but this >is not always respected in other layers, hence the official limit of >32KB (for the safety sake). > >>> 2. What was broken? >>> 3. What was fixed? >> >> The maximum string length is unchanged. > >Not quite so. It was "fixed" to become limited by 32KB in Beta 2 (IIRC), >as this is a documented maximum string length. Then Ivan Prenosil >complained that 64KB literals were working OK before that change and we >discovered that it's really safe to leave the 64KB limit for literals. > >As already correctly noted, such literals cannot be assigned to anything >but a blob.
Sure; but presumably the xsqlda can carry them? If so, probably the "improvement" here is that a string of nearly 64Kb can be passed safely to a BLOB, although previously it was documented as 32565 (or maybe 32567, can't remember). Helen ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel