freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: Debbie <debbie AT animaro.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] DBD::Sybase MSSQL VARBINARY 255 byte limit
Date: Sun, 3 Sep 2006 17:14:48 -0500

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.

PHP on Linux using the mssql_*() functions and FreeTDS doesn't seem to
have this problem.

Does anyone have a solution? e.g.

- Can I configure DBD::Sybase to support VARBINARY columns >255 bytes?
- Is there a Perl module other than DBD::Sybase I can use to talk to
FreeTDS/MSSQL?
- Or do I have to move my Perl program onto the Windows machine
if I need >255 byte VARBINARY support?

[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