In ODBC Driver (17 and 18) for SQL Server, it will report the size of VARCHAR (MAX) and NVARCHAR (MAX) as 0, causing an optimized bind_data route to be taken and having only the first amount of data ...