FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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