> > >> We also need a way to pass strings of unknown length.
> > >>
> > >
> > > Isn't that limitation of the remote protocol handler?
> > >
> > >
> >
> > The remote protocol sends all strings as counted strings.
> >
> > How do you send a string of unknown length?
>
> By letting the client count the string length, cut it up and send
> it in segments?

Let me get back on this --

How much sense would it make, to let the Firebird Client handle
this?

I mean, let any client component set just "prepare" or "execute"
a 100Mb statement (or whatever). The Firebird client would then
see "hey, that's very very large" and use the appropriate network
stuff so that it prepares something so that the server would then
be ready-ed to accept a very long string as a statement, instead of
1 single statement.

The client would then finish with a "statement finished" and the
server would execute it.

Would this make sense? I understand this is a change in the
wire protocol, but it would finally get Firebird up to date with
regard to sending BLOBs to the server like the SQL Standard
specifies.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com