Subject Re: [ib-support] Maximum varchar insert size?
Author Paul Reeves
alisonnz2001@... wrote:
> Hi all,
> i'm using interbase to store html source for an asp website, and the
> site had been working fine until the users attempted to add quite a
> large article.
> This returned the error '80004005' , which as far as i can work out
> is a kind of catch all ado error.
> All the characters to be inserted are OK (I've inserted the article
> in separate chunks without a problem), and i've extended the size of
> the varchar field to 20000 characters - the article to be inserted is
> roughly 8500.
> The maximum number of char's i have managed to insert is about 7000,
> is this the limit for a single insert query?
> Or can anyone think of a possible workaround?

It looks like you may have reached the limit of the buffer for a single
statement string.

Have you tried a using a parameterised query?


Paul Reeves
taking InterBase further