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.
_______________________________________________
