Subject | Maximum varchar insert size? |
---|---|
Author | alisonnz2001@yahoo.co.uk |
Post date | 2001-03-30T17:03:06Z |
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?
thanks very much in advance..
Alison
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?
thanks very much in advance..
Alison