Skip to main content


Set the MaxLen for ODBC fields of type VarChar.


[SQL]    ODBCVarcharMaxlen=n

n is any nonnegative integer. The maximum value is the maximum string length. The default value is 4096.


ODBCVarcharMaxlen is the MaxLen (maximum length) that InterSystems IRIS® data platform will report to ODBC for fields with the data type VarChar.

Changing This Parameter

You can change ODBCVarcharMaxlen with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).