Myrna, I changed the maximumdisplaywidth to 600 and IJ is returning the
correct values for the clob field. Thanks again.
Brian
Myrna van Lunteren wrote:
Hi Brian,
ij has a default maximum display width per column of 128.
If you change it, you will see more.
For instance,
ij> maximumdisplaywidth 360;
Will return 360 characters.
Myrna
On 8/17/05, *Brian Bonner* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi again. Here's what I did:
I create a table in derby via the eclipse plugin.
connect 'jdbc:derby:clobtest;create=true';
create table clobber(id int primary key, content clob(100 K));
insert into clobber values
(1,'11111111111111111111111111111111111111111111111111111111222222222222222222...');
with 594 characters in the string.
but when I do:
select * from clobber;
ID
|CONTENT
--------------------------------------------------------------------------------------------------------------------------------------------
1
|1111111111111111111111111111111111111111111111111111111122222222222222222222222222222222222222222222222222222222222222222222222&
I only get 128 characters of the clob back.
If I change the content field to be a long varchar and run the same
thing again, I get the same results from IJ, but if I use a different
tool, (Data Explorer in Eclipse for instance), I get all of the data
back from the long varchar table, but still only 128 characters in the
clob side.
Maybe this is just the limitation of how the clob behaves in both
tools. I was expecting to see all of the data in both cases.
Any thoughts on this?
Brian
--
Brian
