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

Debbie debbie at animaro.com
Sun Sep 3 19:25:23 EDT 2006


On Sun, Sep 03, 2006 at 06:38:39PM -0400, jklowden at schemamania.org wrote:
> On Sun, Sep 03, 2006 at 05:14:48PM -0500, Debbie wrote:
> > 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.  

Ahh, thank you!! I was using

DBI->connect('dbi:Sybase:host=127.0.0.1;port=1433')

I switched to using:

DBI->connect('dbi:Sybase:server=MSSQL')

with this ~/etc/freetds.conf:

[MSSQL]
host = 127.0.0.1
port = 1433
tds version = 8.0

and now it's able to read VARBINARY columns without truncating them to
255 characters. Thanks again.



More information about the FreeTDS mailing list