Skip to Content.
Sympa Menu

freetds - Re: [freetds] Long column names and PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thomas, Christopher (LLU)" <cwthomas AT llu.edu>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Long column names and PHP
  • Date: Wed, 27 Sep 2006 09:51:32 -0700

Thanks for the tip. You are right that I was connecting using 4.2. I
couldn't find the version from the TDSDUMP. But I checked the output
from phpinfo() and it said 7.0, but I guess the freetds.conf file
overrides whatever PHP has selected. After I changed the version inside
freetds.conf to 8.0, everything worked perfectly. Funny thing is
phpinfo() still reports 7.0.

Chris

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Tuesday, September 26, 2006 7:13 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Long column names and PHP

Thomas, Christopher (LLU) wrote:
> One of my tables has a column name that is really long (a little over
30
> characters). [...] When the
> results are returned, for the long column name, it is truncated to
just
> the first 30 characters. How do I get the full column name to be
> returned?

That would happen if you're connecting with TDS 4.2 instead of 7.0 or
8.0.
Check your TDSDUMP log or try selecting from a varchar wider than 255
characters. If it's truncated, you're using TDS 4.2.

HTH.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page