#16509 [Opn->Fbk]: mssql_fetch_array limit on fieldname-length

From: Date: Mon, 07 Oct 2002 02:07:08 +0000
Subject: #16509 [Opn->Fbk]: mssql_fetch_array limit on fieldname-length
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-21685@lists.php.net to get a copy of this message 
 ID:               16509
 Updated by:       iliaa@php.net
 Reported By:      vincent@sunlight.tmfweb.nl
-Status:           Open
+Status:           Feedback
 Bug Type:         MSSQL related
 Operating System: Win2K
 PHP Version:      4.1.1
 New Comment:

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




Previous Comments:
------------------------------------------------------------------------

[2002-04-09 05:51:03] vincent@sunlight.tmfweb.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

Thread (5 messages)

« previous php.bugs (#21685) next »