freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: jklowden AT schemamania.org
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] DBD::Sybase MSSQL VARBINARY 255 byte limit
Date: Sun, 3 Sep 2006 18:38:39 -0400

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

[freetds] DBD::Sybase MSSQL VARBINARY 255 byte limit, Debbie, 09/03/2006
- Re: [freetds] DBD::Sybase MSSQL VARBINARY 255 byte limit, jklowden, 09/03/2006
  - Re: [freetds] DBD::Sybase MSSQL VARBINARY 255 byte limit, Debbie, 09/03/2006