(odbc) text size limits?

I noticed mssql have a very small text size by default. Need to find how to change this (preferably in the application).

`SELECT @@TEXTSIZE` returns 4096 can use `set textsize 65356; SELECT @@TEXTSIZE;`
to increase it for the duration of a query, but was not able to find an way to get unlimited.

remember to update the docs with findings.