#31283 [NEW]: 30 character column name limit

From: james at brendata dot co dot uk Operating system: Windows NT4 PHP version: 5.0.1 PHP Bug Type: MSSQL related Bug description: 30 character column name limit 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 bug report at http://bugs.php.net/?id=31283&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31283&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31283&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31283&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=31283&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=31283&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=31283&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=31283&r=needscript Try newer version: http://bugs.php.net/fix.php?id=31283&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=31283&r=support Expected behavior: http://bugs.php.net/fix.php?id=31283&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=31283&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=31283&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=31283&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31283&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=31283&r=dst IIS Stability: http://bugs.php.net/fix.php?id=31283&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=31283&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=31283&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=31283&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=31283&r=mysqlcfg