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.


Dmitry


------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to