Omg...it's bad enough that we have to use a MS SQL server...but running our code on Windows...thankfully, that's not a problem we have. Thanks for the suggestion though, John.
As far as my research has gone so far, it appears at this point that the TEXTSIZE setting is a server-side setting, while the LongReadLen is driver side, but I haven't found adequate documentation - or even discussion - to support or refute that. ________________________________ From: John Scoles [mailto:byter...@hotmail.com] Sent: Tuesday, May 17, 2011 12:23 PM To: Berg, Eric: IT (NYK); dbi-users@perl.org Subject: RE: What's the relationship between LongReadLen and TEXTSIZE? Martin Evans would be the expert on that. But it does sound funny that TEXTSIZE is working and LongReadLen is not?? LongReadLen should work no matter the driver. Perhaps you should try DBD::ADO > From: eric.b...@barclayscapital.com > To: dbi-users@perl.org > Date: Tue, 17 May 2011 12:11:55 -0400 > Subject: What's the relationship between LongReadLen and TEXTSIZE? > > I'm setting up to use DBD::ODBC with the FreeTDS driver to go against a MS > SQL server and am hoping to nail down the specifics of the relationship > between setting $dbh->{LongReadLen} and TEXTSIZE. > > So far, LongReadLen has had exactly no impact on retrieval of long data from > my MS sql server. Regardless of to what LongReadLen is set, the data that I > retrieve is complete beyond the LongReadLeng setting as long as TEXTSIZE is > adequately large. > > Setting TEXTSIZE to a value that is less than the length of the data, > however, does result in truncated data returned from the dataserver. > > Additionally, truncated values end with an extended ascii char...probably a > null...I have to admit I haven't looked yet. > > So, can we just ignore LongReadLen? We're migrating from Sybase, and have > been using LongReadLen as a connection parameter in Sybase for years to set > the size of long data returned by the dataserver. > > Any light you can shed on this is appreciated. > > Eric > > _______________________________________________ > > This e-mail may contain information that is confidential, privileged or > otherwise protected from disclosure. If you are not an intended recipient of > this e-mail, do not duplicate or redistribute it by any means. Please delete > it and any attachments and notify the sender that you have received it in > error. Unless specifically indicated, this e-mail is not an offer to buy or > sell or a solicitation to buy or sell any securities, investment products or > other financial product or service, an official confirmation of any > transaction, or an official statement of Barclays. Any views or opinions > presented are solely those of the author and do not necessarily represent > those of Barclays. This e-mail is subject to terms available at the following > link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent > to the foregoing. Barclays Capital is the investment banking division of > Barclays Bank PLC, a company registered in England (number 1026167) with its > registered office at 1 Churchill Place, London, E14 5HP. This email may > relate to or be sent from other members of the Barclays Group. > _______________________________________________ _______________________________________________ This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing. Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP. This email may relate to or be sent from other members of the Barclays Group. _______________________________________________
