#31283 [Opn->Csd]: 30 character column name limit
| From: | james at brendata dot co dot uk | Date: | Fri, 24 Dec 2004 10:44:10 +0000 |
| Subject: | #31283 [Opn->Csd]: 30 character column name limit | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-71035@lists.php.net to get a copy of this message | ||
ID: 31283
User updated by: james at brendata dot co dot uk
Reported By: james at brendata dot co dot uk
-Status: Open
+Status: Closed
Bug Type: MSSQL related
Operating System: Windows NT4
PHP Version: 5.0.1
New Comment:
We have just found this in 23990, it is a DBLIB issue with Microsoft.
Previous Comments:
------------------------------------------------------------------------
[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