Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: dbd::sybase string cut at 78 characters?

by Anonymous Monk
on Jun 14, 2010 at 23:41 UTC ( #844758=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://844758]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2021-01-19 19:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?