[freetds] FreeTDS returned data lenght????

Michael Peppler mpeppler at peppler.org
Wed Oct 15 09:36:43 EDT 2003


On Wed, 2003-10-15 at 04:08, David Nsengiyumva wrote:
> Hi Everybody,
> 
> Does anyone know how FreeTDS knows the lenght of the returned data; not the
> size of the result set, but the individual data in each field of every
> particular row in the result set????
> 
> For what I see, in the ct-lib layer, the " ct_describe " function sets the
> members of the CS_DATAFMT parameter (datafmt) using the TDSCOLINFO (curcol)
> structure ("column_size" field of the structure). But what I don't
> understand is that when I run a Query that's supposed to return strings
> whose lenght is more than 45 it works but when the fields of the returned
> values include Date/Time data then it fails.

A CS_DATETIME data item is 8 bytes in length - it's not the length of
the string into which it could be converted.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler at peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html


More information about the FreeTDS mailing list