Skip to Content.
Sympa Menu

freetds - Re: How to read Strings bigger than 255 chars

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT speakeasy.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: How to read Strings bigger than 255 chars
  • Date: Sun, 03 Jun 2001 19:18:31 +0000


Paul Schaap wrote:

> > I saw that freeTDS cannot read Strings from the (SQLServer7)database with
> > a length bigger than 255. freeTDS simply cuts the String.
> > This happens with datatypes char, varchar, nvarchar, nchar. Any Ideas?
>
> Cast them as type "TEXT".
>
> P.S. the FAQ is confused/ing here !

Confused, methinks.

Are you referring to http://216.254.83.209/freetds/html/x515.htm?

"The best current solution is convert long strings to varchar(8000) in your
query
text with CAST( variable_name as varchar(2000) ) as variable_name."

Not so? Should that read "CAST(variable_name as text) as variable_name"? Or
does it
depend on what client-server-version combination you're using? Tell the
truth,
please. No point in updating one lie with another.

You see, if the fellow who wrote the documentation actually knew what he was
talking
about, this sort of silliness wouldn't happen. Other kinds of silliness,
maybe, but
not this kind.

Thanks, Paul.

--jkl






Archive powered by MHonArc 2.6.24.

Top of Page