MAXLENGTH for VARCHAR in ODBC

[Michoel Reach]

In the documentation  Data Types | Caché SQL Reference | Caché & Ensemble 2018.1.4 – 2018.1.8 (intersystems.com)

it says that "by default, Caché establishes a system-wide ODBC VARCHAR maximum length of 4096; this ODBC maximum length is configurable"

Per instructions, I went to SMP -> System -> Configuration -> General SQL Settings, where most of the fields from  $SYSTEM.SQL.CurrentSettings()Opens in a new ta

appear. That one does not.

How does one change it, and can it be increased?

Thanks!

[Michoel Reach]

Solved by Lucas Fernandes

at https://community.intersystems.com/post/maxlength-varchar-odbc
Thanks!