The 255 char limitation is a protocol level limitation. You need to make sure that you connect to your MS-SQL server with TDS 8 (you set this in the freetds.conf file, IIRC).

Once that is done then you should be able to retrieve varchar columns wider than 255 (or at least there is no limit in DBD::Sybase that would prevent that.)

As an aside, LongReadLen has nothing to do with this - that's for BLOB-type columns (in Sybase/MS-SQL parlance that's TEXT and IMAGE data).

Michael

PS: keep in mind that I don't use FreeTDS, or MS-SQL at all, so the above is pretty much all I know about the matter...

In reply to Re: MS SQL (DBD::SyBase) varchar limitation by mpeppler
in thread MS SQL (DBD::SyBase) varchar limitation by boo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.