[Firebird-devel] SQL Statement Length

[Andy C. <an...@ad...>]

It is important for the client application to limit the length of SQL =
statements so as to avoid buffer overflow errors. Yet I am unable to =
find any explicit limit on SQL statement length in the beta =
documentation. For isc_dsql_prepare() and isc_dsql_execute_immediate(), =
the statement length can be given as an UNSIGNED SHORT parameter. This =
imples that the maximum statement length is less than 65,536 bytes. My =
guess is that the maximum SQL statement length that Firebird can handle =
is 32,767 bytes, the same as the maximum length of a CHAR VARYING field. =
But it is never stated. Does anyone know?