I found online that the maximum storage size of a varchar(max) is 2^31-1 bytes (2 GB).
Why the data was truncated when it is over 23678 characters?
I query a byte array column in Postgre table in SSIS. The data is transferred and stored in SQL Server column with varchar(max). It stores only up to 23678 characters.
Any suggestions what it can be done?