rubyfreetdstiny-tds

Streaming large files using TinyTDS/FreeTDS

When I run a simple select on a row, I only get about 64K of data for BLOB columns. I'd like to get all of it, streaming would be preferable of course to avoid memory problems.

Solution

  • Good morning,

    IIRC, FreeTDS defaults to a 64K limit for text size. In your freetds.conf try changing this setting:

    text size = 64512

    to something like this:

    text size = 4194304

    The maximum size of a text field in SQL Server, as an example, is 2,147,483,647 bytes.