db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: Copy varchars from table A to Blobs in Table b?
Date Mon, 14 Jan 2008 08:48:36 GMT
Jim Murphy wrote:
> I can't seem to convert/cast from plain old varchars to blobs.  
> I have a table of biggish varshars that in a new DB schema are now modeled
> as blobs.  In writing the conversion script I can't figure a way to select
> varchars from one tabel and insert them into the other.
> Any ideas?

Do you have a special requirement in your application, since a Blob 
column is chosen over a Clob column to hold the VARCHAR data?

If you can use a Clob column, I think the conversion problem might just 
go away.


> Thanks
> Jim

View raw message