[freetds] DBD::Sybase MSSQL VARBINARY 255 byte limit

jklowden at schemamania.org jklowden at schemamania.org
Sun Sep 3 18:38:39 EDT 2006


On Sun, Sep 03, 2006 at 05:14:48PM -0500, Debbie wrote:
> Hello,
> 
> I am using Perl DBD::Sybase on Linux, attempting to fetch VARBINARY
> columns from an MSSQL database. When I fetch columns that are longer
> than 255 bytes however, it gets truncated.

Sounds like you're using TDS 4.2.  Make sure you're using TDS version 7.0
or 8.0 with your server.  Cf. http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFFORMAT.  

HTH.

--jkl




More information about the FreeTDS mailing list