Re: 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.	[reply]
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	[reply]
Re^3: dbd::sybase string cut at 78 characters? by Anonymous Monk on Jun 15, 2010 at 12:29 UTC
Hi - done, see here: http://lists.ibiblio.org/pipermail/freetds/2010q2/026052.html	[reply]