[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