#16509 [Com]: mssql_fetch_array limit on fieldname-length

ID: 16509 Comment by: rhittos at shaw dot ca Reported By: vincent at sunlight dot tmfweb dot nl Status: No Feedback Bug Type: MSSQL related Operating System: Win2K PHP Version: 4.1.1 New Comment: I am using the latest release of PHP 5.0 build 2195, release date Apr 25 2004 12:10:13. I am also experiencing this problem. Previous Comments: ------------------------------------------------------------------------ [2002-10-22 01:00:02] php-bugs at lists dot php dot net No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-10-06 21:07:08] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-04-09 05:51:03] vincent at sunlight dot tmfweb dot nl When getting an associative array from a MSSQL database: with mssql_fetch_array(), the keys of the array can be no longer than 30 characters. I have a field 'last_modification_user_login_id' (31 characters) in a table 'document', but after selecting all fields from that table, I can't access that field. A var_dump however on the array shows a key 'last_modification_user_login_i', which is 30 characters. It has the right value. This is not a problem with: - Databases: the same code works with MySQL and PostgreSQL on the 'same' database. - Arrays: keys can be longer than 30 characters So it has to be a 'mssql_fetch_array' bug! Vincent ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16509&edit=1