DB2 Details:
- product name : DB2/LINUXX8664
- version : 10.5.0.5
As per DB2 docs, Maximum length of varchar
is 32704 bytes
I tried:
create table t_varchar (c1 varchar(32673));
Got the error:
Error: DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611, SQLERRMC=varchar(32673), DRIVER=4.14.111 SQLState: 42611 ErrorCode: -604
It allowed me to create varchar with max length 32672.
Is this desired behaviour or am I doing something wrong?
Simlilarly, for CHAR I am not able to create table with char(255)