Thread: max query length

max query length

From
dean browett
Date:
Hi,

Can anyone tell me whether there is a maximum query length using 'insert'?

We want to insert a text statement into our db. This statement may be up to
20k in size.

Dean





Re: [GENERAL] max query length

From
Marc Tardif
Date:
I think there is no maximum on the actual query length, but there is a
limit on the max row size. If I remember correctly, there is an 8k limit
to the contents of an entire row. If you need more than that, either split
your data across multiple rows are use the blob data type.

Marc

On Fri, 4 Feb 2000, dean browett wrote:

> Hi,
>
> Can anyone tell me whether there is a maximum query length using 'insert'?
>
> We want to insert a text statement into our db. This statement may be up to
> 20k in size.
>
> Dean
>
>
>
>
>
> ************
>
>