ID: 31283
Updated by: [EMAIL PROTECTED]
Reported By: james at brendata dot co dot uk
-Status: Closed
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows NT4
PHP Version: 5.0.1
New Comment:
Marking as "bogus" as it's both a duplicate and not a bug in PHP.
Previous Comments:
------------------------------------------------------------------------
[2004-12-24 11:44:09] james at brendata dot co dot uk
We have just found this in 23990, it is a DBLIB issue with Microsoft.
------------------------------------------------------------------------
[2004-12-24 11:26:15] james at brendata dot co dot uk
Description:
------------
Only a limit of 30 characters on a column name, regardless of how long
the column name is. We are using the column names as a way of passing
data.
Reproduce code:
---------------
<?php
$msconnect=mssql_connect("hostname","username","password");
mssql_select_db("any db",$msconnect);
$sql = <<<EOT
select 1 as a23456789012345678901234567890123456789 from syscolumns
EOT;
$msresults=mssql_query($sql);
$row = mssql_fetch_array($msresults, MSSQL_ASSOC);
print_r($row);
?>
Expected result:
----------------
Array ( [a23456789012345678901234567890123456789] => 1 )
Actual result:
--------------
Array ( [a23456789012345678901234567890] => 1 )
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31283&edit=1
