[freetds] Mapping of MS SQL data types to C/PHP data types
Trilok Khairnar
trilokgk at gmail.com
Mon Jan 4 11:06:47 EST 2010
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
>
More information about the FreeTDS
mailing list