[freetds] Perl pulling data from SQL Server using FreeTDS
v79k at yahoo.com
Tue May 18 18:48:31 EDT 2004
--- "James K. Lowden" <jklowden at schemamania.org>
> On Mon, 17 May 2004, v79k <v79k at yahoo.com> wrote:
> > Is there a limit of 256 bytes for FreeTDS? Column
> 1 is
> > basically tab limited data.
> No. FreeTDS imposes no limit. The server or TDS
> version might, though.
> varchar in < TDS 7.0 is limited to 255 characters.
-- I use FreeTDS 8.0 since MS SQL Server 2000. The
server has no limit. Actually, there is a limit but it
is very high.
> > Will breaking into individual columns help?
> Eh, well, many people would call that better design.
> Of itself, better
> design often helps.
-- I tend to agree. The SP was just written that way.
Its working now. Instead of returning varchar, we are
returning text which in the server has a limit that
will not be reached very often.
Thanks for sharing your thoughts,
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
More information about the FreeTDS