There is a table that columns charset as iso88591, when expect to return 20K column size, in fact it returns the length as 3392.
sqws139.houston.hp.com, T2 driver.
Step 1. Create a table as below,
sql = "create table tblcolumnsize200kWithISO88591(c1 char(200000) character set iso88591 collate default null, c2 char(200000) character set iso88591 collate default null)";
iRet = stmt.executeUpdate(sql);
Step 2. Insert 20K column size into the above table.
Step 3. Execute query as below,
sql = "select left(rtrim(t.c1), 200000) as o1 from tblcolumnsize200kWithISO88591 as t";
rs = stmt.executeQuery(sql);
Step 4. Compare the first column o1 size returned from ResultSet object.
At the Step 4, it will throw an exception like 'Exception in thread "main" java.lang.AssertionError: expected: <200000> but was: <3392>'