http://www.perlmonks.org?node_id=844758


in reply to dbd::sybase string cut at 78 characters?

Hi,

Is it always 78?
Many years ago I worked with Sybase via DBI
and I seem to remember that the length of the
string that could be passed into Sybase was
limited, 128 chars( ? ). I had to break up the line with
\n, then it was fine.

May have some bearing.


J.C.
  • Comment on Re: dbd::sybase string cut at 78 characters?

Replies are listed 'Best First'.
Re^2: dbd::sybase string cut at 78 characters?
by rgcosma (Beadle) on Jun 15, 2010 at 00:01 UTC
    Hello,

    the length is always 78, and

    I find no reference to such an issue - it would be quite strange, the nvarchar(MAX) is 2^31-1 according to Microsoft's docs.
Re^2: dbd::sybase string cut at 78 characters?
by derby (Abbot) on Jun 15, 2010 at 12:24 UTC

    Hmmm ... well that /\w{70,}/ may be the culprit but maybe not. You should either set a trace on the DBI handle (see the perldoc) or just log the actual sql and values -- I would want to know *if* I'm generating the correct sql *before* I start blaming the underlying library (freetds) or the db.

    -derby
      Hi - done, see here: http://lists.ibiblio.org/pipermail/freetds/2010q2/026052.html