[freetds] Mapping of MS SQL data types to C/PHP data types

Damien Churchill damoxc at gmail.com
Mon Jan 4 11:32:31 EST 2010

2010/1/4 Trilok Khairnar <trilokgk at gmail.com>:
> I should clarify that this is not a FreeTDS issue, but a question on
> programming a FreeTDS app using PHP/ C.
> I am wondering whether there is a performance penalty if the data type
> is not specifed when using mssql_result in mssql_result($result,$i) to
> get the ith column from a result set $result, or using odbc_result
> from PHP's ODBC module API.
> I also looked up the documentation of sqlsrv_get_field for MS SQL
> server driver for PHP.
> It says: "If no return type is specified, a default PHP type will be
> returned". However, at what level is the type inferencing done?
> Thanks,
> Trilok
> On Mon, Jan 4, 2010 at 8:35 PM, Trilok Khairnar <trilokgk at gmail.com> wrote:
>> Is the mapping of MS SQL data types to C/PHP data types documented somewhere?
>> e.g. A similar mapping between SQL and CLR is documented here:
>> Mapping CLR Parameter Data http://msdn.microsoft.com/en-us/library/ms131092.aspx
>> Thanks,
>> Trilok
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

might possibly be of interest. Not sure how much help it will be

More information about the FreeTDS mailing list