Toad World® Forums

cannot display varchar(32000)

For Version Toad for DB2
IBM DB2 64 bit client
LUW Z/OS Xpert Trial

Just installed this version. For one column defined as varchar(32000) in one of the table, for newly inserted rows, cannot display that column, I need to click the cell to see the content, but for existing rows the content can display.

Thank you for any help!

It can be so if you have a carriage return in 1st row in your xml.
Toad will display 1st row for not focused cell.

This is an example:

create table varchar32k (col1 varchar(32000));
insert into varchar32k (col1) values (‘XML strings’);
insert into varchar32k (col1) values (’
new XML strings’);