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

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]