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

Reply via email to