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


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

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

by Anonymous Monk

on Jun 14, 2010 at 23:41 UTC ( [id://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.	[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]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://844758]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others having a coffee break in the Monastery: (4)

As of 2024-04-23 15:52 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found