Max Length Of Varchar

[238963]

Please anyone let me know what is the maximum length of varchar datatype in db2 tat can we use

[ganeshmn25]

Hi dude,

In IBM DB2 Maximum length of a VARCHAR column 32767 bytes


Regards

Padmanaban.N

DB2 Database Associate

[spider007]

Keep in mind though that you will have to create a tablespace and a bufferpool of size 32K if you want to use varchar of that size.

Also, I am not really sure whether it will accept 32767.