Re: java.sql.SQLException: IO Error: encoded string too long: 126164 bytes

I ran into a similar problem no so long ago.  It seems to occur when the
SQL command, in total size, exceeds 64K.

Nick

On Sat, 2006-06-10 at 07:17 +1200, Duncan Groenewald wrote:

> Mmm..  I just used the following command and things worked fine:
> 
> insert into HTMLTemplates (Code, Description, HTML)
> select '004', 'New Template', HTML
> from HTMLTemplates
> where Code = '001'
> 
> and it worked just fine.
> 
> Not sure if this helps but is the problem perhaps with the JDBC driver ? 
> Or could it be a java bug ?
> 
> Duncan
> 
> Duncan Groenewald wrote:
> 
> > I get this error when trying to insert a long piece of text into a 
> > longvarchar field.  This seems to be a new problem because I already 
> > have a record in the same table and was copying it to another record 
> > when I got the error.
> >
> > Any ideas and what is wrong or how I got the record inserted in the 
> > first place.  I was under the impression than longvarchar has a limit 
> > of around 1 billion characters, did I misunderstand something ?
> >
> > Thanks
> > Duncan
> >
> >
> > ---------------------------------------------------------------
> > Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> > To unsubscribe, send a message to [email protected]
> >
> >
> 
> 
> 
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to [email protected]
>