ID: 40986
Updated by: [EMAIL PROTECTED]
Reported By: Arne dot Heizmann at csr dot com
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2000
PHP Version: 5.2.1
New Comment:
This is a limit in the MSSQL library (ntwdblib.dll) used to build the
extension. Use the php_dblib.dll version of the extension. This version
is build with FreeTDS and does not have these limitations.
This has been reported many times before. Please search the archives
before posting the same bugs over and over.
Previous Comments:
------------------------------------------------------------------------
[2007-04-03 17:43:05] Arne dot Heizmann at csr dot com
Description:
------------
The function mssql_field_name() appears to return only the first 30
characters of the field name.
Reproduce code:
---------------
<?
$sql = 'select 1 as [This is a field name that is longer than 30
characters]';
$mssqlh = mssql_pconnect ('server', 'username', 'password'); //
change as appropriate
mssql_select_db ('databasename', $mssqlh); //
change as appropriate
$result = mssql_query ($sql, $mssqlh);
$fieldname = mssql_field_name ($result, 0);
var_export ($fieldname);
?>
Expected result:
----------------
'This is a field name that is longer than 30 characters'
Actual result:
--------------
'This is a field name that is l'
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=40986&edit=1
